insert into table1 (val1,val2,val3)
select val1,val2,val3
from table2
where id in (?,?,?,?,...)