select tbl_orders.dept_code, dept_name from tbl_dept
right join tbl_orders on tbl_dept.dept_code = tbl_orders.dept_code
union
select tbl_sales.dept_code, dept_name from tbl_dept
right join tbl_sales on tbl_dept.dept_code = tbl_sales.dept_code
order by 1 ;