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