Where同時in 2欄位

-MS-SQL-

同時要二個條件成立的 Where


Oracle: --------------------------------------------------
SELECT * FROM T1 WHERE (C1,C2) IN (SELECT C1,C2 FROM T2)


Sql 2005: --------------------------------------------------

select * from
(
select Ta, Tb from T1
) X
where not exists (
SELECT C1,C2 FROM T2
Where C1 = Ta and C2 = Tb
)


看出來沒, 很奇妙吧!