mysql 查询a表在b表中不存在的记录

select * from tbl_user a where(select count(1) as cnt from tbl_order b where a.phone=b.phone)=0

  

原文地址:https://www.cnblogs.com/6min/p/10861969.html