MySQL SELECT multiple rows in one table, SUM on different table with WHERE statement

Question

I'm trying to figure out how create a MySQL SELECT statement that will select users from one table, get the SUM of their payments in another table for each user, and set a conditional statement on that SUM. Something like this:

SELECT member_id
FROM users_table
WHERE SUM(payments) FROM payments_table > 100;

Any help would be greatly appreciated.

Ian Kenney · Accepted Answer · 2014-07-07 19:52:59Z

2

something like

select member_id from payments_table 
group by member_id 
having sum(payments) > 100

or

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

edited Jul 7, 2014 at 19:52

answered Jul 7, 2014 at 19:40

Ian Kenney

6,4561 gold badge27 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Leo Bali Over a year ago

i guess this query will work fine because member_id is a foreign key in the payment table .. is that the case ?

Collectives™ on Stack Overflow

MySQL SELECT multiple rows in one table, SUM on different table with WHERE statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related