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

Chapter 6. Querying with SQL Statements > Viewing the SQL Statement

Viewing the SQL Statement

Before getting to the SQL specifics, let's first see how the Design view and the underlying SQL are related. Figure 6.1 shows a basic query using the Northwind database's Customers table. The query displays the CompanyName and ContactName fields, and the criteria “USA” is applied to the Country field.

Figure 6.1. A simple query on the Customers table.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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