SELECT
a.mobile
FROM
tp_users a
WHERE
( SELECT count( 1 ) FROM tp_integral_member b WHERE a.mobile = b.phone ) = 0
Mysql查询一个字段a表存在但b表不存在的数据
最新推荐文章于 2023-07-20 19:31:36 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
SELECT
a.mobile
FROM
tp_users a
WHERE
( SELECT count( 1 ) FROM tp_integral_member b WHERE a.mobile = b.phone ) = 0