select dept.DEPT_CODE, DEPT_NAME
from(
select DEPT_CODE
from TBL_ORDERS
union
select DEPT_CODE
from TBL_SALES
) as dept
left join TBL_DEPT
on dept.DEPT_CODE = TBL_DEPT.DEPT_CODE
order by dept.DEPT_CODE