user_a表如下:
user_b表如下:
查询语句如下:
SELECT
user_a.`user`,
Sum(user_a.money),
Count(user_a.`user`)
FROM
user_a
GROUP BY
user_a.`user`
HAVING
user_a.`user` NOT IN ((select user from user_b group by user))
运行结果:
user_a表如下:
user_b表如下:
查询语句如下:
SELECT
user_a.`user`,
Sum(user_a.money),
Count(user_a.`user`)
FROM
user_a
GROUP BY
user_a.`user`
HAVING
user_a.`user` NOT IN ((select user from user_b group by user))
运行结果: