select
  EMP_CODE
  , EMP_NAME
  , D.DEPT_CODE
  , DEPT_NAME
from
  TBL_EMPLOYEES AS E
left outer join
  TBL_DEPT AS D
on
  E.DEPT_CODE = D.DEPT_CODE
order by
  EMP_CODE
  , E.DEPT_CODE
;