之前网站上看了很多行转列,感觉写的好复杂,好麻烦,我这边自己写一个吧 。。。
不废话,直接上代码:
1: 主表 SELECT * FROM WMS_Loan a where a.IsDelete = 0 (入库主表)
2:子表 select * from WMS_LoanDetail b (入库详情表)
3:关联关系为:
select * from WMS_Loan a
left join WMS_LoanDetail b
on a.ID = b.LoanID
4:我需要把 子表 仓库名称(ExWarehouse),用','号隔开,并且显示未一列
select a.ID,
ExWarehouses = ( STUFF(( SELECT ',' + ExWarehouse
FROM WMS_LoanDetail b
WHERE b.LoanID = a.id
FOR
XML PATH('')
), 1, 1, '') )
from WMS_Loan a
where I