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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access