The databases and query examples below are based on MS Access and the underlying Microsoft Jet SQL query engine. An online reference of the Jet SQL syntax is available here. For the most important statements, clauses and functions, direct links are provided below:

Statements

• SELECT Statement
• SELECT...INTO Statement
• INNER JOIN Operation
• LEFT JOIN, RIGHT JOIN Operations
• UNION Operation

Clauses

• FROM Clause
• GROUP BY Clause
• HAVING Clause
• IN Clause
• ORDER BY Clause
• WHERE Clause

Functions

• Count Function
• Min, Max Functions
• Sum Function
• Avg Function
• StDev Function