摘要：
select n.*,columnname=stuff((select ','+m.fname from (select a.id,b.id as bid ,a.fname from s_projectdata a , (select operationtype,id from som_ent_enterprise) b where charindex(convert(varchar(10),a.id),b.operationtype) > 0 and parentid = '2') mwhere m.bid=n.id for xml path(' 阅读全文