This is a document Template
 
SQL OUTER LEFT JOINT:

SELECT e.ENAME, e.JOB , d.LOC, d.deptno FROM emp e left outer join DEPT d ON e.deptno = d.deptno where d.loc ='CHICAGO'

 
ORACLE

POSTGRESQL
MYSQL