select
    td.dept_code
from tbl_dept as td
left outer join tbl_orders as tor
on td.dept_code = tor.dept_code
union
select
    td.dept_code
from tbl_dept as td
left outer join tbl_sales as ts
on td.dept_code = ts.dept_code
order by td.dept_code