SQL Copy one table records to another table - INSERT RECORD FROM ONE TABLE TO ANOTHER - COPY TABLE

 INSERT INTO newTable

SELECT * FROM oldTable

For single column

 INSERT INTO orders(customer_id)

SELECT customer_id FROM Customers

https://stackoverflow.com/questions/13237623/copy-data-into-another-table