select 
    TE.EMP_CODE 
    ,TE.EMP_NAME 
    ,TD.DEPT_CODE 
    ,TD.DEPT_NAME 
from
TBL_EMPLOYEES as TE join TBL_DEPT as TD on TE.DEPT_CODE = TD.DEPT_CODE
order by TE.EMP_CODE asc , TD.DEPT_CODE ;