若有兩個table(Table1:Name,Email兩個欄位;Table2:NameName,Email兩個欄位)， 請問一下，要如何下SQL語法取得在Table1但是不在Table2的名單(name,email) 也就是說Table1 - Table2的名單。 謝謝各位大大的幫忙！

Hi:    

 
SELECT  *
FROM    TABLE1 T1
WHERE   NOT EXISTS (SELECT ''
                    FROM    TABLE2 T2
                    WHERE   T1.NAM2 = T2.NAME
                    AND     T1.EMAIL = T2.EMAIL)    或是
SELECT  *
FROM    TABLE1 T1
WHERE   (NAME,EMAIL) NOT IN (SELECT NAME
                                    EMAIL
                             FROM   TABLE2)    

-------------------------------- 小弟才疏學淺，若有謬誤請不吝指教 --------------------------------

------
Fishman

SELECT * FROM TABLE1 WHERE NAME NOT IN (SELECT NAME FROM TABLE2) try it

SELECT * FROM TABLE1 T1 WHERE (NAMEA,EMAIL) NOT IN (SELECT NAMEA,EMAIL FROM TABLE2) 這一句在sql2000會有錯哦 Line 3: Incorrect syntax near ','. 我試了一下修改成這樣 SELECT * FROM TABLE1 T1 WHERE NAMEA NOT IN (SELECT NAMEA FROM TABLE2)