Bugl — Daily coding puzzles and drills

SELECT INTO Keyword

command copies data from one table and inserts it into a new table. The following SQL statement creates a backup copy of Customers:

SELECT * INTO CustomersBackup2017
FROM Customers;

The following SQL statement uses the IN clause to copy the table into a new table in another database:

SELECT *
INTO CustomersBackup2017 IN 'Backup.mdb'
FROM Customers;

The following SQL statement copies only a few columns into a new table: SELECT CustomerName, ContactName INTO CustomersBackup2017

FROM Customers;

The following SQL statement copies only the German customers into a new table:

SELECT *

WHERE Country = 'Germany';

The following SQL statement copies data from more than one table into a new table:

SELECT Customers.CustomerName, Orders.OrderID

ON Customers.CustomerID = Orders.CustomerID;