select distinct orders.DEPT_CODE, DEPT_NAME
from tbl_dept as dept
right outer join tbl_sales as sales on dept.dept_code = sales.dept_code
right outer join tbl_orders as orders on dept.dept_code = orders.dept_code
order by orders.dept_code