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;
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;