ÇóSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

A±í
AID A_col1 A_col2 A_col3
1 200 a12 a13
2 200 a22 a23
3 200 a32 a33
4 201 a42 a43
5 201 a52 a53
6 201 a62 a63

B±í
BID B_col1 B_col2 B_col3
1 200 1,2 b13
2 200 3 b23
3 201 4,5,6 b33

±íµÄ¹Øϵ:
B_Col2 ΪAIDµÄ×éºÏ

A_col1 ÖеÄÖµ¶ÔÓëB_col1ÊÇÓжÔÓ¦¹Øϵ

ÏëÈ¡µÄ½á¹ûΪ:
200 a12 a13 b13
201 a42 a43 b33
201 a53 a53 b33
(½âÊÍÒ»ÏÂ: ´ÓA±íÑ¡³öÒ»×éÊý,ͨ¹ýB±íµÄCol1,ÓëCol2 µÄ¹Øϵ °ÑB±íµÄCol3¹Òµ½A±íºóÃæ )

---

SQL code:
select a.*
from a,b
where charindex(','+ltrim(a.aid)+',',','+B_col2+',')>0

---

SQL code:
select A_COL1,A_col2,A_col3,B_col3
from A JOIN B ON A.A_col1=B.B_col1
where CHARINDEX(RTRIM(a.AID),b.B_COL2)>0

---

ÒýÓÃ

SQL code
select a.*
from a,b
where charindex(','+ltrim(a.aid)+',',','+B_col2+',')>0

ÐÞÕýһϣ¬Â¥Ö÷¸øµÄ½á¹ûòËÆÒ²²»¶Ô°¡
SQL code:
if object_id('[A]') is not null drop table [A]
go
create table [A]([AID] int,[A_col1] int,[