• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Working with Structured Quer... > Writing SELECT Queries in SQL

Writing SELECT Queries in SQL

When you create a SELECT query in Query Design mode, Access translates the 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 return a specified set of records from one or more tables. The following lines of syntax are used for an 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 qualifying rows (records) of a source table:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint