REPLACE VIEW v AS SELECT x1 FROM TABLE_1 UNION SELECT x2 FROM TABLE_2 UNION; SELECT x3 FROM TABLE_3; SELECT * FROM v;