Progress
SQL-92
Guide and 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
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. See the "Outer Joins" and "Search Conditions" sections in "SQL-92 Language Elements" for information on the different kinds of search conditions.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |