Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## WHERE clause

> Specifies a search condition that applies conditions to restrict the number of rows in the result table. If the query expression does not specify a `WHERE` clause, the result table includes all the rows of the specified table reference in the `FROM` clause.

> #### Syntax

>     WHERE search_condition

> ``search_condition``

> Applied to each row of the result table set of the `FROM` clause. Only rows that satisfy the conditions become part of the result table. If the result of the search_condition is `NULL` for a row, the row is not selected. Search conditions can specify different conditions for joining two or more tables.

> Example

> For customers with orders, retrieve their names and order info:

>     SELECT Name, City, State
>          FROM Customer
>          WHERE State = 'NM' ;

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095