Question: what is the difference between select into and insert into select?
Answer: INSERT INTO SELECT inserts into an existing table. SELECT INTO creates a new table and puts the data in it. All of the columns in the query must be named so each of the columns in the table will have a name.