Progress
SQL-92
Guide and Reference


Query Expressions

A query expression selects the specified column values from one or more rows contained in one or more tables specified in the FROM clause. The selection of rows is restricted by a search condition in the WHERE clause. The temporary table derived through the clauses of a select statement is called a result table.

Query expressions form the basis of other SQL statements and syntax elements:

This is the syntax for a query_expression:

SYNTAX
query_specification
 | query_expression set_operator query_expression
 | ( query_expression ) 


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