SELECT
  emp.EMP_CODE,
  EMP_NAME,
  dept.DEPT_CODE,
  DEPT_NAME
FROM
  TBL_DEPT AS dept
  FULL OUTER JOIN TBL_EMPLOYEES AS emp ON dept.DEPT_CODE = emp.DEPT_CODE
ORDER BY
  EMP_CODE asc,
  dept.DEPT_CODE asc;