David Ackerman David Ackerman - 3 months ago 8
SQL Question

join two tables into one big table

I have two tables with the same columns, and I need to copy one table's rows to the other table's rows to create one big table with all the values from both tables. Right now I am doing this query to return the same thing:

SELECT col1, col2, col3 from Table1
union
SELECT col1, col2, col3 from Table2


However, it seems horribly inefficient, and on my system is very slow (returns 1210189 records).

Answer

May it work to just do:

SELECT col1, col2, col3 
INTO Table1
FROM Table2