34,590
社区成员
发帖
与我相关
我的任务
分享
select [article],
stuff((select ','+ltrim(A.result),B.DResult from B join A on B.id=A.id
where [article]=t.[article] for xml path('')),1,1,'') [A.id]
from A t
group by [article];
select b.value2,a.value1
from a join b on a.type1 = b.type2