SELECT INTO

Database Dictionary -> SELECT INTO

SELECT INTO

SELECT INTO is a variation of the SELECT SQL command, used to insert the retrieved data into database table. Both retrieval and insertion are done at the same time.

SQL Tutorial