SELECT * FROM Table1 WHERE id NOT IN (SELECT id FROM Table2)
SELECT * FROM table1 t1 WHERE NOT EXISTS (SELECT 1 FROM table2 t2 WHERE t1.id = t2.id)
1510阅读 0评论2014-05-22 tkchks
分类:Mysql/postgreSQL
SELECT * FROM Table1 WHERE id NOT IN (SELECT id FROM Table2)
SELECT * FROM table1 t1 WHERE NOT EXISTS (SELECT 1 FROM table2 t2 WHERE t1.id = t2.id)