need to use left join so the building number stays the same

need to use left join so the building number stays the same #988