我想弄清楚如何创建一个MySQL SELECT
语句,它将从一个表中选择用户,在另一个表中为每个用户获得他们的支付的SUM
,并在该SUM
上设置一个条件语句。像这样:
SELECT member_id
FROM users_table
WHERE SUM(payments) FROM payments_table > 100;
类似
select member_id from payments_table
group by member_id
having sum(payments) > 100
或
select u.member_id, u.name
from payments_table p
join users_table u
on p.member_id = u.member_id
group by u.member_id, u.name
having sum(p.payments) > 100