摘要：1 SELECT *2 FROM Table1 a3 LEFT JOIN Table2 b4 ON a.Col1 = b.Col1 AND a.Col2 = b.Col25 WHERE b.Col1 IS NULL适用非Oracle的数据库，还有一种写法总感觉没这优雅，因为用了NOT EXISTS1 SELECT *2 FROM Table13 WHERE NOT EXISTS (4 SELECT *5 FROM Table26 WHERE Col1 = Table1.Col17 AND Col2 = Table1.Col28 ) 阅读全文