SELECT A.*
,STUFF((SELECT ','+B.Name FROM B WHERE CHARINDEX(CAST(B.Id AS VARCHAR(10)),A.userId)>0
FOR xml PATH('') ),1,1,'' ) AS names
FROM A
聚合查询尝试
最新推荐文章于 2024-01-01 19:37:51 发布
SELECT A.*
,STUFF((SELECT ','+B.Name FROM B WHERE CHARINDEX(CAST(B.Id AS VARCHAR(10)),A.userId)>0
FOR xml PATH('') ),1,1,'' ) AS names
FROM A