David Ackerman David Ackerman - 2 months ago 5x
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
SELECT col1, col2, col3 from Table2

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


May it work to just do:

SELECT col1, col2, col3 
INTO Table1
FROM Table2