not in 与 left out join select A.mobile from A left outer join B on (A.mobile=B.mobile) where B.mobile is null 等价于 select A.mobile from A where A.mobile not in (select B.mobile from B)