SELECT * FROM A WHERE ID NOT IN (SELECT ID FROM B)
SELECT * FROM A WHERE ID NOT IN (SELECT ID FROM B)
除非注明， askADC博客 的文章均为原创，转载请注明作者和出处。
本文链接地址: http://blog.askadc.com/mysql%e6%90%9c%e7%b4%a2%e8%a1%a8a%e4%b8%ad%e7%9a%84%e6%95%b0%e6%8d%ae%e5%9c%a8%e8%a1%a8b%e4%b8%ad%e6%b2%a1%e6%9c%89%e7%9a%84id/