Special Edition Using Access 97, Second Edition

Writing Select Queries in SQL

When you create a SELECT query in Query Design mode, Access translates the QBE query design into a Jet SQL SELECT statement. You can view the Jet SQL equivalent of your design at any point by choosing View, SQL View. Displaying and analyzing the SQL statements that correspond to queries you design or queries in the Northwind Traders sample database is useful when you are learning SQL.

The heart of SQL is the SELECT statement used to create a select query. Every select query begins with the SELECT statement. The following lines of syntax are used for a SQL SELECT statement that returns a query table (called a result set, usually a Recordset object of the Dynaset type) of all or selected columns (fields) from all or ...