O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required