SELECT
    TE.EMP_CODE AS EMP_CODE,
    TE.EMP_NAME AS EMP_NAME,
    TD.DEPT_CODE AS DEPT_CODE,
    TD.DEPT_NAME AS 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,
    TE.DEPT_CODE ASC;