implicit left outer join tests added