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