（我的）SQL：在'INSERT INTO ... SELECT'中获取新ID

I have to insert into one table the records selected from another table and (then) update the former table with the generated id for the latter. How can I do it?I have to insert into one table the records sel