select 
    TE.EMP_CODE 
    ,TE.EMP_NAME 
    ,TD.DEPT_CODE 
    ,TD.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 , TD.DEPT_CODE ;