--sql server 查询sql
SELECT '显示列' = STUFF(( SELECT ',' + b.typeName
FROM outside_goods_item b
where PATINDEX('%,' + RTRIM(goodsTypeId) + ',%',',' + c.bnScopeName + ',')>0
ORDER BY PATINDEX('%,' + RTRIM(goodsTypeId) + ',%',',' + c.bnScopeName + ',')
--加上排序不变(如:2,1,3)
FOR XML PATH('')), 1, 1,''),c.agencyName,c.bnScopeName
FROM carrier c
--mySql 查询sql
select c.id,c.bnScopeName,GROUP_CONCAT(b.typeName) as '经营范围'
from carrier c JOIN outside_goods_item b
ON FIND_IN_SET(b.goodsTypeId,c.bnScopeName)
GROUP BY c.id