SELECT
    EMP_CODE,
    EMP_NAME,
    TBD.DEPT_CODE AS DEPT_CODE,
    TBD.DEPT_NAME AS DEPT_NAME
FROM
    TBL_EMPLOYEES AS TBE
    FULL JOIN TBL_DEPT AS TBD
    ON TBE.DEPT_CODE = TBD.DEPT_CODE
ORDER BY
    EMP_CODE,DEPT_CODE;