add left outer join