International SQL-Ledger Network Association

This is an old revision of the document!

---

 SELECT ar.id, invnumber, ar.amount, (SELECT SUM(amount) FROM acc_trans ac WHERE ac.trans_id = ar.id AND ac.chart_id IN (SELECT id FROM chart WHERE link NOT LIKE '%_paid%')) amount2 FROM ar WHERE paid <> 0 AND id IN (SELECT trans_id FROM acc_trans GROUP BY trans_id HAVING SUM(amount) = 0) GROUP BY 1,2,3;