modify left outer join