Building a query with two tables using SUM

Question

I have two tables that I need to gather data from, then add up the sum of one field and return it if the sum is over a certain amount.

Affiliates Table - Table1: [id]
Commissions Table - Table1: [affiliate_id][amount]

I need to grab only affiates where the total commissions 'amount' is over 30.

I will also need to return all of the data from both tables into a single array.

Burak Guzel · Accepted Answer · 2010-12-27 23:37:18Z

1

Try using the HAVING clause.

SELECT affiliate_id, SUM(amount) total_amount 
FROM commissions GROUP BY affiliate_id 
HAVING total_amount > 30

answered Dec 27, 2010 at 23:37

Burak Guzel

1,2951 gold badge12 silver badges12 bronze badges

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

1 Answer 1