Hi:
Yes, if table1 and table2 have the same structure you can do something like this:
insert into table1 select * from table2
Of course, you can use a where clause on the select or even use a subset of the table structure:
insert into table1(col1, col2, col3) select col1, col2, col3 from table2 where col1 = "something"
Regards,
Ed