Mysql查询一个字段a表存在但b表不存在的数据
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表不存在的数据
SELECT
a.mobile
FROM
tp_users a
WHERE
( SELECT count( 1 ) FROM tp_integral_member b WHERE a.mobile = b.phone ) = 0