Returns all rows that meet the join criteria and allows for non matching
rows to be returned on the column to the left of the ‘=’ sign.
SELECT ename, dname
FROM emp e
LEFT OUTER JOIN dept d ON e.deptno = d.deptno
ORDER BY dname;
ENAME DNAME
---------- --------------
SMITH ACCOUNTING
FORD RESEARCH
ADAMS RESEARCH
SCOTT RESEARCH
JONES RESEARCH
JAMES SALES
TURNER SALES
BLAKE SALES
MARTIN SALES
WARD SALES
ALLEN SALES
RIGHT OUTER JOIN
Returns all rows that meet the join criteria and allows for non matching
rows to be returned on the column to the left of the ‘=’ sign.
SELECT ename, dname
FROM emp e
RIGHT OUTER JOIN dept d ON e.deptno = d.deptno
ORDER BY dname;
ENAME DNAME
---------- --------------
SMITH ACCOUNTING
OPERATIONS
JONES RESEARCH
SCOTT RESEARCH
FORD RESEARCH
ADAMS RESEARCH
ALLEN SALES
JAMES SALES
TURNER SALES
BLAKE SALES
MARTIN SALES
WARD SALES
I'm stmontgo and I approve of this message