complex query

[wikstov]

Hello all,

This is the situation:
I have a table 'member' from which I want to retrieve all member names for members whose sum of 'payments' exceeds a certain amount (fixed, e.g. 200)

how the hell can I do this??

tables:
member: memberID, name
payment: memberID, amount

I know I need a subquery for the sum(), but I just can't get it to work

thanks a lot for your help and comments

[rachel2004]

$amount = "200.00";
$sql = "SELECT m.name, sum(p.amount) AS total FROM members AS m LEFT JOIN payment AS p ON (m.memberID = p.memberID) GROUP BY m.name HAVING (total > ".$amount.")";