Is there a way of getting all the rows used in a group?
As you would expect, the query below only returns one row per custref
. But if totalamount
is > 0, I want it to return all the rows in the group. Otherwise none.
$sql = "SELECT
debtors.custref,
debtors.amount,
users.bnkSort,
users.bnkAccNum,
users.bnkAccName,
SUM(debtors.amount) AS totalamount
FROM debtors
LEFT JOIN users ON debtors.custref=users.custref
WHERE
users.bank = 'Yes'
GROUP BY debtors.custref
";