This is a
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'