表B
ID(FK) Memos
001 football
001 sing
001 internet
查询结果需要是
ID Name Memos
001 lid football,sing,internet
...全文
364打赏收藏
求一sql,有点难度
注意:出于执行效率的考虑,不用游标(循环), 表A ID(主键) Name 001 lid 002 like 表B ID(FK) Memos 001 football 001 sing 001 internet 查询结果需要是 ID Name Memos 001 lid football,sing,internet
select distinct a.id,ltrim(rtrim(a.memos))+','+rtrim(ltrim(b.memos))+','+rtrim(ltrim(c.memos)) as memos into #tmp from 表B a,表B b,表B c
where a.id=b.id and b.id=c.id and a.memos<b.memos and b.memos<c.memos
select a.id,a.name,b.memos from 表A a,#tmp b where a.id=b.id