insert into table using a select from another table

By | 16 February, 2011

Following the update with data from another table, i am leaving this for quick reference.

To insert data into table2 from table2:

insert into table2 (field1,field2,field3) 
select table1.field1,table1.field2,table1.field3 from table1

(all the above is on the same line)

We can make this as complex as needed.