Dla postgresa 8.2.1 cos takiego na 100% dziala niestaty nie wiem czy tej konstrukcji pozwala użyć MySQL
SELECT customers.id, a.porabacie, b.balance FROM customers JOIN (SELECT SUM(ROUND((tariffs.value*(100-assignments.discount))/100,2)) AS porabacie, assignments.customerid FROM assignments LEFT JOIN tariffs ON (tariffs.id = assignments.tariffid) WHERE suspended=0 AND (datefrom <= current_timestamp OR datefrom = 0) AND (dateto >= current_timestamp OR dateto = 0) GROUP BY assignments.customerid) a ON (a.customerid = customers.id) JOIN (SELECT SUM(value) AS balance, customerid FROM cash GROUP BY customerid) b ON (b.customerid = customers.id) GROUP BY customers.id, a.porabacie, b.balance HAVING (a.porabacie * -2) >= b.balance
Dzięki, działa jak złoto :) Próbowałem podobnie, ale poległem :/