change default (inner)join to left outer join