Not sure I understand your a useless (IMO) inner join is generated while customer references no home address. AFAICS, you require the address in the projection?

What I'm wondering is if it should maybe be a left join instead of an inner join.