Assuming I've understood the question, this works for me:
SELECT c.name,
COALESCE(balance,00.0)
FROM customer c LEFT OUTER JOIN
(
SELECT i.id custId,
SUM(i.value) balance
FROM invoice i
GROUP BY custId
)
ON c.id=custId;
Results, where each company has multiple invoices recorded against it,
except for DDD Pty Limited, which has none:
AAA Pty Limited|223.46
BBB Pty Limited|1555.54
CCC Pty Limited|200.02
DDD Pty Limited|00.0
EEE Pty Limited|999.99
Regards.
rayB
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
