select DISTINCT t.DEPT_CODE,
d.DEPT_NAME
from (
select DEPT_CODE from TBL_SALES
UNION ALL
select DEPT_CODE from TBL_ORDERs
) t
left join TBL_DEPT d
on d.DEPT_CODE = t.DEPT_CODE
order by t.DEPT_CODE ASC