select 
    EMP_CODE,
    EMP_NAME,
    td.DEPT_CODE,
    DEPT_NAME
from 
    TBL_EMPLOYEES as te
    full outer join TBL_DEPT as td
        on te.DEPT_CODE = td.DEPT_CODE
order by 
    EMP_CODE asc,
    td.DEPT_CODE asc;