do left outer join instead of right