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