select
    e.emp_code
    ,e.emp_name
    ,d.dept_code
    ,d.dept_name
from
    tbl_employees e full outer join tbl_dept d
    on e.dept_code = d.dept_code
order by
    e.emp_code asc, d.dept_code asc
;