Queries with SQL

Select Query

SELECT * FROM tblCustomers
SELECT * FROM tblCustomers WHERE Name=SMITH

Make-Table Query

SELECT CustomerID, FirstName, LastName, CustStatus
INTO NewTable
FROM tblCustomer
WHERE CustStatus="ACTIVE"

Append Query

INSERT INTO tblCustomers ("Name, Address, City, State, Zip)
VALUES ("Joe Customer", "123 Main Street", "New York", "NY", "00110")

Update Query

UPDATE tblCustomers SET ZipCode="60060" WHERE City="Chicago"

Delete Query

DELETE * FROM tblCustomers

Home