Category:SQL

Basics

Select

The SELECT statement is used to assemble fields of different tables and queries to a new result.

Examples

• Selecting all fields from a table

SELECT *
  FROM tbl

• Selecting two fields from a table

SELECT field1
     , field2
  FROM tbl

Insert

• INSERT INTO

Update

• UPDATE

Delete

• DELETE

Joins

Distinct

Sub Select

Formatting

• Well Formed SQL Statements

Special SQL

• Microsoft Access OLEDB

Tools