SQL_INNER_FULL_OUTER1.htm
SQL :

SELECT d.deptno,substr(d.dname,1,7)"dname" ,d.loc, e.ename, e.job FROM dept d inner join emp e ON d.deptno = e.deptno where d.deptno in(10, 30) order by d.deptno

full outer join

SELECT d.deptno "dno",substr(d.dname,1,7)"dname" ,substr(d.loc,1,5)"loc", e.ename, e.job FROM dept d full outer join emp e ON d.deptno = e.deptno where e.deptno in(10, 30) order by d.deptno

row : 2 
 
ORACLE:

INNER

full outer

POSTGRESQL

INNER-JOIN

FULL-OUTER