with tmp as(
select DEPT_CODE from TBL_ORDERS
union
select DEPT_CODE from TBL_SALES)
select a.dept_code,
(select b.dept_name
   from tbl_dept b
  where b.dept_code = a.dept_code) as DEPT_NAME
  from tmp a
order by a.dept_code