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.

  Previous topic Next topic  

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.