select
    EP.EMP_CODE as EC,
    EP.EMP_NAME as EN,
    DP.DEPT_CODE as DC,
    DP.DEPT_NAME as DN
from
    TBL_EMPLOYEES as EP
    FULL outer join TBL_DEPT as DP
order by
    EC asc,
    DC asc;