--联查

select n.*,t.Name from News n join Type_News tn on n.Id=tn.NId join Types t on t.Id=tn.TId

--拼接并插入临时表

select aaa.Title,aaa.Content, stuff((select ',' + ttt.Name from (select n.*,t.Name from News n join Type_News tn on n.Id=tn.NId join Types t on t.Id=tn.TId ) as ttt for xml path('')),1,1,'') as field into #T from (

select n.* from News n join Type_News tn on n.Id=tn.NId join Types t on t.Id=tn.TId

) aaa

drop table #T

select * from #T

 

--分组查询

select ROW_NUMBER() over(order by Title) as rowId, * from #t group by Title,content,field