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

Chapter 6. Querying with SQL Statements > Using SQL to Perform a Select Query

Using SQL to Perform a Select Query

As you've seen, the most basic type of query is the select query that returns records from one or more tables based on the fields you choose and the criteria you apply to those fields. This is called a select query not only because you use it to select certain records, but also because it's based on the SQL language's SELECT statement (see Figure 6.2). SELECT is the SQL “verb” that you'll see and work with most often, so this section gives you a detailed look at its syntax.

Understanding the SELECT Statement

The SELECT statement is used to create a dynaset based on the tables, fields, criteria, and other clauses specified in the statement. Here's the basic syntax of the SELECT statement:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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