In a left outer join all values not avalable will become null and you are trying an inner join on the client table with a null value. That is why the rows are missing... add a left outer join on the client table..

Also if you use sum(isnull(invoice.total, 0)) it will be 0 in stead of null in the outer join rows 🙂