Set Operators in View Definitions - Advanced SQL Engine - Teradata Database

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;