SQL两张表联合查询

其他回答

--创建测试数据drop table #acreate table #a(idd int,name2 varchar(10),image2 varchar(10),tag2 varchar(10))insert into #a values(1,'长城','。','长城')insert into #a values(1,'故宫','。','故宫')insert into #a values(1,'天安门','。','天安门')drop table #bcreate table #b(id int,name varchar(10),image varchar(10),tag varchar(10))insert into #b values(1,'爱情1','。','长城')insert into #b values(2,'天空','。','故宫')insert into #b values(3,'23爱','。','长城')insert into #b values(2,'蓝天','。','故宫')---------------实现代码部分----------------select * from #aselect * from #bselecttag,max(t2.idd) as idd,max(t2.name2) as name2,max(t2.image2) as image2,(select name+'、' from #b t1 where t1.tag =tt.tag for xml path('')) as name,(select image+'、' from #b t1 where t1.tag =tt.tag for xml path('')) as imagefrom#b ttleft join #a t2 on t2.tag2 =tt.taggroup bytag--查询结果/*tagiddname2image2nameimage长城1长城。爱情1、23爱、。、。、故宫1故宫。天空、蓝天、。、。、*/