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)
not in 与 left out joinselect 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)