记一次sqlServer一个字段存储另一张表的多个id时查询名称
select a.auto_id,a.shopping_name,STUFF( (select ','+CONVERT(varchar,b.label_name) from s_label as b where 1=1 and CHARINDEX( ','+CONVERT(varchar,b.auto_id), ','+a.la...