初始表结构
运行结果
select id, STUFF((SELECT ',' + realname from v_dim_zslxr_01 subtitle
where id=a.id FOR XML PATH('')),1,1,'') realname from v_dim_zslxr_01 a
group by id
初始表结构
运行结果
select id, STUFF((SELECT ',' + realname from v_dim_zslxr_01 subtitle
where id=a.id FOR XML PATH('')),1,1,'') realname from v_dim_zslxr_01 a
group by id