SELECT * ,主管领导姓名 = STUFF(( SELECT ',' + 姓名 FROM b WHERE PATINDEX('%,' + RTRIM(序号) + ',%', ',' + a.主管领导 + ',') ORDER BY PATINDEX('%,' + RTRIM(序号) + ',%',',' + a.主管领导 + ',') --加上排序不变(如:2,1,3) FOR XML PATH('') ), 1, 1, '') FROM a
链接:https://bbs.csdn.net/topics/390932211?page=1