Copy Table Over

Hi everone,
I have one table called temp and I am copying its content over to another table called final. The final table has 2 more coloumns than the temp table, 1 of which is a primary key, and the other one is calculated. What is the easiest way I can do this?

Thank you for the answer.

Try this:

Select *, One_column,Second_column into final from temp