SELECT temp.EMP_CODE
    ,temp.EMP_NAME
    ,tdep.DEPT_CODE
    ,tdep.DEPT_NAME
FROM TBL_EMPLOYEES AS temp
FULL OUTER JOIN TBL_DEPT AS tdep
ON temp.DEPT_CODE = tdep.DEPT_CODE

ORDER BY temp.EMP_CODE
    ,tdep.DEPT_CODE;