It appears that you are missing a ) after the fields you have listed

Insert into table1 (field1, field2) select fielda, fieldb from table2

http://www.w3schools.com/sql/sql_insert_into_select.asp