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