|
Selecting Data Advantage Database Server v8.1: A Developer’s Guide by Cary Jensen and Loy Anderson © 2007 Cary Jensen and Loy Anderson. All rights reserved. |
|
|
The richest statement in SQL is the SELECT statement, and it is used to retrieve data from Advantage to the client application. This section begins with a look at simple selections involving fields and expressions. Later, you will learn how to select specific records, as well as how to sort, group, and link data from two or more tables.