August 2002
Intermediate to advanced
528 pages
10h 12m
English
This chapter starts a discussion of the SELECT command, which is the most commonly used SQL command. It is used to retrieve records and attributes from the database, and it has many powerful tools that allow you to format the retrieved data into meaningful information. This command will be the most important tool you will have in order to provide your users with the information that they request.
The SELECT command (or statement) contains six clauses, the first three of which will be discussed in this chapter. Subsequent chapters will continue the discussion of the SELECT command clauses and other powerful tools called functions that you can use with the ...