Hi Thanks again for the reply - I now have the following:

SELECT

months.monthid,

months.month,

months.realmonthid,

isnull(SUM(invoices.cinvoicesubtotal),0) AS Total,

isnull(clients.clientname,'')

FROM

months

LEFT OUTER JOIN

invoices ON months.realmonthid = MONTH(invoices.invoicedate)

LEFT OUTER JOIN

clients ON invoices.clientid = clients.clientid

WHERE invoices.invoicedate BETWEEN '01-apr-2007' AND '31-mar-2008'

GROUP BY

months.monthid,

months.month,

months.realmonthid,

clients.clientname,

invoices.invoicedate

ORDER BY months.monthid

Unfortunately I'm still only being presented with the months with invoices in them 🙁