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