With SQL, you can copy information from one table into another. The SELECT INTO statement copies data from one table and inserts it into a new table.
www.w3schools.com