select*from dbo.np_syyp
select*from dbo.np_yptest
select*,STUFF((select ','+zb.testname from np_yptest zb
where zb.syypid=mb.syypid for XML path('')),1,1,'') AS SUMNAME from np_syyp mb
sql把子表多条数据进行组合
select*from dbo.np_syyp
select*from dbo.np_yptest
select*,STUFF((select ','+zb.testname from np_yptest zb
where zb.syypid=mb.syypid for XML path('')),1,1,'') AS SUMNAME from np_syyp mb
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
