SELECT E.EMPLOYEE_ID, E.LAST_NAME, D.DEPARTMENT_ID, D.DEPARTMENT_NAME FROM HR.EMPLOYEES E LEFT OUTER JOIN HR.DEPARTMENTS D ON E.DEPARTMENT_ID = D.DEPARTMENT_ID SELECT E.EMPLOYEE_ID, E.LAST_NAME, D.DEPARTMENT_ID, D.DEPARTMENT_NAME FROM HR.EMPLOYEES E ,HR.DEPARTMENTS D WHERE E.DEPARTMENT_ID= D.DEPARTM Read More
