REPLACE VIEW v AS SELECT * FROM table_1 UNION SELECT * FROM table_2; INSERT table_3(x3,y3) SELECT * FROM v;