SELECT E.EMP_CODE , E.EMP_NAME , D.DEPT_CODE , D.DEPT_NAME
FROM TBL_EMPLOYEES E FULL OUTER JOIN TBL_DEPT D ON E.DEPT_CODE = D.DEPT_CODE
ORDER BY E.EMP_CODE ,D.DEPT_CODE;