如有表A
ID Name
20 a
120 b
30 c
41 d
51 e
再有表B
Qu IDN
la 41
lb 30，20,120
从A表中查询所有值，加上B表中IDN中有A表ID号的Qu值..不太会表达 。。想要的结果如下：
ID Name Qu
20 a lb
120 b lb
30 c lb
4 d la
51 e 空值或NUll
------解决方案--------------------
- SQL code
--> 测试数据: @表Adeclare @表A table (ID int,Name varchar(1))insert into @表Aselect 20,'a' union allselect 120,'b' union allselect 30,'c' union allselect 41,'d' union allselect 51,'e'--> 测试数据: @表Bdeclare @表B table (Qu varchar(2),IDN varchar(10))insert into @表Bselect 'la','41' union allselect 'lb','30,20,120'select a.*,b.Qu from @表A a left join @表B b on charindex(','+ltrim(a.ID)+',',','+b.IDN+',')>0/*ID Name Qu----------- ---- ----20 a lb120 b lb30 c lb41 d la51 e NULL*/