Need to Know use of Right outer join....
For example: first query left outer join for emp table : SELECT EMPNO,ENAME,D.DEPTNO FROM EMP E , DEPT D WHERE E.DEPTNO=D.DEPTNO( )
Second Query left outer join for Dept table: SELECT EMPNO,ENAME,D.DEPTNO FROM EMP E , DEPT D WHERE D.DEPTNO=E.DEPTNO( )
In above example i have just swap where condition to get outer join of both table with left outer join condition itself. Then wat is use of Right outer join, Instead i can swap the table name condition to get the output. Please suggest.................