WITH C AS (
SELECT DISTINCT DEPT_CODE FROM TBL_ORDERS
UNION ALL
SELECT DISTINCT DEPT_CODE FROM TBL_SALES
)
SELECT DISTINCT C.DEPT_CODE, DEPT_NAME FROM C
LEFT JOIN TBL_DEPT AS D ON D.DEPT_CODE = C.DEPT_CODE
ORDER BY C.DEPT_CODE