Besides simple queries, UNION can be used within the following operations:
- Derived tables You cannot use the HASH BY or LOCAL ORDER BY clauses in derived tables with set operators.
- Subqueries
- INSERT ... SELECT statements
- Non-recursive CREATE VIEW statements
UNION ALL is the only valid set operator in a WITH RECURSIVE clause or CREATE RECURSIVE VIEW statement that defines a recursive query.