SELECT *
FROM
(SELECT
DEPT_CODE
FROM TBL_ORDERS
UNION
SELECT
DEPT_CODE
FROM TBL_SALES)
LEFT JOIN TBL_DEPT AS B
USING(DEPT_CODE)
ORDER BY DEPT_CODE;