SQL实用技巧：如何将表中某一列的部分数据合并到一行中

select *,stuff(select ‘,’ + fieldname from table1 for xml path(”)),1,1,”)  as  field from table2select *,stuff(select ‘,’ + fieldname from table