Is this not as simple as changing the first INNER JOIN to a LEFT JOIN?

A word of advice - alias your tables, and use the aliases to qualify every column name, whether in the SELECT list, the WHERE clause or a join predicate.  It'll make your query easier to ready and guard against ambiguous column names in the future.

John