I'm missing something really silly in a query.
I want to produce a list of accounts, the invoices and receipts and the
balance against them.
Simply, there is an accounts table, invoices and receipts.
I want to show the account details, sum(invoices), sum(receipts) and the
balance. There is a
=account.accountId
GROUP BY account.accountId
) AS combined
GROUP BY account.acountId
- Original Message -
From: webmaster [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, January 30, 2007 6:28 AM
Subject: Joins with sums
I'm missing something really silly in a query.
I want to produce