select 
    tmp.DEPT_CODE,
    DEPT_NAME
from tbl_dept as d
right outer join(
    select dept_code from tbl_orders group by dept_code
    union 
    select dept_code from tbl_sales group by dept_code
) as tmp
on d.dept_code=tmp.dept_code
order by tmp.dept_code;