Çósql ·½·¨ - MS-SQL Server / ÒÉÄÑÎÊÌâ

±íA 
Field A1(Varchar) A2
record 1 1
record 2 1
record 3 1

±íB
Field B1(Varchar) B2
record 1,2,5,6 1


ÒªÇ󣬲éÕÒ³ö A1±íÖÐA1×ֶεÄÖµ£¬ÔÚB±íB1ÖУ¬Ìõ¼þA2=B2

---

SQL code:
select a1 from a where exists(select 1 from b where charindex(','+ltrim(a.a1)+',',','+b1+',')>0 and a.a2=b2)

---

ÈçºÎ·µ»Ø

---

for xml path()

---

record ÕⶫÎ÷ÊÇ×Ö¶ÎÄÚÈÝ»¹ÊǶàÓàµÄ£¿

---

select A.* from A , B where A2=B2 and charindex(','+A1+',',','+B1+',')>0

---

SQL code:
select A1
from ±íA a
where exists
(select B1
from ±íB b
where b.B2 = a.A2
and charindex(',' + a.A1 + ',', ',' + b.B1 + ',') > 0)


1.exists:ÓÃÀ´¹ýÂ˼ǼµÄ£¬Ï൱ÓÚÌõ¼þ
2.CHARINDEXº¯Êý·µ»Ø×Ö·û»òÕß×Ö·û´®ÔÚÁíÒ»¸ö×Ö·û´®ÖеÄÆðʼλÖᣲ»´æÔÚ·µ»Ø 0£»
  CHARINDEXº¯Êýµ÷Ó÷½·¨ÈçÏ£º 
  CHARINDEX ( expression1 , expression2 [ , start_location ] )

---

SQL code:
select A1
from ±íA a
left join ±íB b
on a.A2 = b.B2
where charindex(',' + a.A1 + ',', ',' + b.B1