sql 字段合并问题 字段A相同把字段B扔到同一个字段 sql server 2005

select A , (select B+',' FROM tb WHERE A=b.A ORDER BY A FOR XML PATH('')) AS B from tb b group by A