TODO:
Have you ever wanted to create a table from the results of a SELECT statement?
SOLUTION:
select * into newtable_tmp from oldtable
NOTES:
This statement will select all columns and records from the table "oldtable", and create a new table called "newtable_tmp" that contains the results of the SELECT statement.