17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT GROUP_CONCAT(d_name SEPARATOR ',')drugde FROM department WHERE FIND_IN_SET(d_id,(SELECT drugde FROM drug WHERE drugid =2))
SELECT drugid ,`drugname`, c.typename drugtype, `drugprice` ,
GROUP_CONCAT(b.d_name SEPARATOR ',') drugde ,`drugre`, `drugstatus`, `drugcom` ,drugcon
FROM drug a LEFT JOIN department b ON b.d_id = a.drugde
LEFT JOIN drugdata c ON c.drugtype =a.drugtype
SELECT `drugid`, `drugname`, c.typename drugtype, `drugprice` , GROUP_CONCAT(d_name) drugde ,`drugre`, `drugstatus`, `drugcom` ,drugcon
FROM drug a LEFT JOIN department b ON FIND_IN_SET( d_id,drugde)
LEFT JOIN drugdata c ON c.drugtype =a.drugtype GROUP BY a.drugid