SELECT
 TE.EMP_CODE,
 TE.EMP_NAME,
 TD.DEPT_CODE,
 TD.DEPT_NAME
FROM
 TBL_DEPT AS TD
FULL JOIN
 TBL_EMPLOYEES TE ON TE.DEPT_CODE = TD.DEPT_CODE
ORDER BY
 TE.EMP_CODE ASC,
 TD.DEPT_CODE ASC;