Example
REPLACE VIEW v AS SELECT x1 FROM TABLE_1 UNION SELECT x2 FROM TABLE_2 UNION; SELECT x3 FROM TABLE_3; SELECT * FROM v;
Example
REPLACE VIEW view_2 AS SELECT * FROM view_1 UNION SELECT * FROM table_3 UNION SELECT * FROM table_4; SELECT * FROM view_2 ORDER BY 1,2;
Example
REPLACE VIEW v AS SELECT x1 FROM table_1 WHERE x1 IN (SELECT x2 FROM table_2 UNION SELECT x3 FROM table_3 ); SELECT * FROM v;