HP 3000 Manuals

ALLBASE/Turbo CONNECT Administrator's Guide

Appendix D  Using the SELECT Command 

The SELECT command is an SQL command which is used to retrieve data from
one or more tables or views.  The retrieved data is presented in the form
of a table, called the query result.  With the SELECT command you can
look at particular columns or rows to obtain the exact data desired.
This appendix describes:

 *  The SELECT Command Structure.

 *  Getting Ready to Use the SELECT Command.

 *  The Select List.

 *  The WHERE Clause.

 *  The GROUP BY and HAVING Clauses.

 *  The ORDER BY Clause.

 *  Joining Multiple Tables.

MPE/iX 5.0 Documentation