added outer join with fetch