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