Set operators are permitted within view definitions.
For example, the following REPLACE VIEW statement uses UNION within a view definition:
REPLACE VIEW view_1 AS SELECT x1,y1 FROM table_1 UNION SELECT x2,y2 FROM table_2;
Set operators are permitted within view definitions.
For example, the following REPLACE VIEW statement uses UNION within a view definition:
REPLACE VIEW view_1 AS SELECT x1,y1 FROM table_1 UNION SELECT x2,y2 FROM table_2;