随笔分类 -  SQL

摘要：select b.clientname,a.goodsname,(select ','+convert(varchar(10),detailid) from C c left join tb_soldbill d on c.detailid=d.idwhere d.clientname=b.clientname and c.goodsname=a.goodsname for xml path(''))from A aleft joinB b on a.Detailid=b.idgroup by b.clientname,a.goodsname 阅读全文