Implementing a Full outer join
Asked By
60 points
N/A
Posted on - 04/14/2012
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.