你应该使用NOT EXISTS.基本上,这是格式:
SELECT FROM Table1 WHERE NOT EXISTS (SELECT 1 FROM Table2 WHERE Table1.Something = Table2.Something)