Implementing a Full outer join

Implementing a Full outer join

Hi There,

There are two methods for implementing.

1st we will apply right outer join and then we will apply left outer join and then merge it.

E.g. Select e.* , d.dname, d.deptno dno, d.loc from scott, emp e

FULL OUTER JOIN

Scott dept d on (e.deptno = d.deptno)

E.g. Drag EMP, DEPT tables as src, now place query transform to make the left outer join then place another query transform to make a right outer join.

Hope this will helpful for you.