From a table of invoices and nominalCodes, I want to be abel to get the total amount of invoices for each nominal code, even if the total is zero.
Code: Select all
SELECT sum(amount)
FROM invoices
WHERE nominalCode IN (4000,4001,4002,4003,4004,4005)
GROUP BY nominalCode
ORDER BY nominalCodeSo I tried a left join:
Code: Select all
SELECT sum(amount) as total
FROM nominalCodes
LEFT JOIN invoices ON invoices.nominalCode=nominalCodes.nominalCode
WHERE nominalCodes.nominalCode IN (4000,4001,4002,4003,4004,4005)
GROUP BY nominalCodes.nominalCode
ORDER BY nominalCodes.nominalCodeAny thoughts?
Thanks
Nunners