介绍我了解的两种方法:
(1) NOT IN ,简单易懂,相对效率低:
SELECT DISTINCT A.ID FROM A WHERE A.ID NOT IN (SELECT ID FROM B)
(2)速度快,效率高,但是逻辑理解有点复杂:
SELECT * FROM B WHERE (SELECT COUNT(1) AS num FROM A WHERE A.ID = B.ID) = 0
介绍我了解的两种方法:
(1) NOT IN ,简单易懂,相对效率低:
SELECT DISTINCT A.ID FROM A WHERE A.ID NOT IN (SELECT ID FROM B)
(2)速度快,效率高,但是逻辑理解有点复杂:
SELECT * FROM B WHERE (SELECT COUNT(1) AS num FROM A WHERE A.ID = B.ID) = 0