逻辑相对复杂,但是速度最快: select * from B where (select count(1) from A where A.ID = B.ID) = 0 转载于:https://www.cnblogs.com/feiyuhuo/p/10748098.html