This is a document Template
SQL_LEFT_RIGHT_OUTER1
RIGHT OUTER JOIN: all rows from the right table (dept), with the matching rows in the left table (emp). The result is NULL in the left side when there is no match.

SELECT e.ENAME, e.JOB , d.* FROM emp e RIGHT outer join DEPT d ON e.deptno = d.deptno

LEFT OUTER JOIN :all rows from the left table (emp), with the matching rows in the right table (dept) It results “NULL” in the right side when there is no match. 

SELECT e.* , d.* FROM emp e left outer join DEPT d ON e.deptno = d.deptno

oracle:left outer JOIN

oracle right outer query

POSTGRESQL

LEFT OUTER JOIN

RIGHT OUTER JOIN
mysql

left outer