select e.EMP_CODE,
e.EMP_NAME,
d.DEPT_CODE,
d.DEPT_NAME
from TBL_EMPLOYEES e
left join TBL_DEPT d
on d.DEPT_CODE = e.DEPT_CODE
order by e.EMP_CODE ASC, d.DEPT_CODE ASC