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.