ÇóÒ»¸öSQLÓï¾ä£¡

ÀýÈ磺
ÓÐÒ»¸öÊý¾Ý±í A

±í½á¹¹
ID      Name
-------------
1        aa
1        bb
1        cc
2        aa
2        bb
2        cc
2        dd
3        cc
3        dd 

²éѯNameµÈÓÚaa²¢ÇÒµÈÓÚccµÄID£¬SQLÓï¾äÔõôд£¿£¿

---

×Ô¼º¶¥£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡

---

SQL code:
select * from
(
select * from tb where Name='aa'
)TT
where ID in(select ID from tb Name='CC')

---

SQL code:
select distinct ID from A where Name = 'aa' and Name='cc'

---

Äã½á¹ûÊÇ£¿£¿£¿........

---

SQL code:
select * from
(
select * from tb where Name='aa'
)TT
where ID in(select ID from tb Name='CC')

---

LZÄãÎÊÌâÃèÊöµÄÓÐÎÊÌâ

---

SQL code:
if not object_id('tb