mysql: select all items from table A if not exist in table B

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)
上一篇:linux删除当前目录下以xxx开头的文件夹
下一篇:ps a查看进程