select
    o.dept_code DEPT_CODE
    ,d.dept_name DEPT_NAME
from
    (select distinct dept_code from tbl_orders) o
    left join tbl_dept d on d.dept_code = o.dept_code
order by
    o.dept_code asc
;