receipts.accountId=account.accountId
GROUP BY account.accountId
) AS combined
GROUP BY account.acountId
- Original Message -
From: "webmaster" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, January 30, 2007 6:28 AM
Subject: Joins with sums
I'm missing something really silly i
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 sit
