select
a.emp_code as EMP_CODE,
a.emp_name as EMP_NAME,
b.dept_code as DEPT_CODE,
b.dept_name as DEPT_NAME
from
tbl_employees a
full outer join tbl_dept b
on a.dept_code = b.dept_code
order by
EMP_CODE asc,
DEPT_CODE asc
;