Changed inner join to left outer join