INSERT INTO Statement Examples

 

SQL statement

Description

 

INSERT INTO Customers
SELECT [New Customers].*
FROM [New Customers]

Selects all records in the New Customers table and adds them to the Customers table

INSERT INTO Employees
SELECT Trainees.*
FROM Trainees
WHERE [Hire Date] < Now() - 30

 

Selects all trainees who were hired more than 30 days ago and adds their records to the Employees table