insert into table2 (name, subject, student_id, result) select name, subject, student_id, result from table1;