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

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

  

posted @ 2019-05-14 14:26  1553  阅读(817)  评论(0编辑  收藏  举报