select *,(select itemname as c from qz_item where parentid=a.id for xml path('')) as childitems from qz_item as a where parentid=0
复制代码
作者: 笒羽 时间: 2020-12-21 11:41
stuff((select ','+ProductName+'×'+convert(nvarchar(50),BuyNum) from tablename where antiorderid=a.id for xml path('')),1,1,'')