Merge SQL Tables: Temporary Table with UNION ALL

You can use the UNION ALL keyword to combine two tables into a temporary table. Here is an example code:

CREATE TEMP TABLE temp_table AS
SELECT * FROM table1
UNION ALL
SELECT * FROM table2;

This will combine the data from table1 and table2 into a temporary table called temp_table. It is important to ensure that the number of columns and data types in both tables match, otherwise errors may occur.