Previous Page | Next Page

The SQL Procedure

table-expression


Defines part or all of a query-expression.
See also: query-expression

SELECT <DISTINCT> object-item<, ... object-item>
<INTO :macro-variable-specification
<, ... :macro-variable-specification>>
FROM from-list
<WHERE sql-expression>
<GROUP BY group-by-item <, ... group-by-item>>
<HAVING sql-expression>

See SELECT Statement for complete information on the SELECT statement.


Details

A table-expression is a SELECT statement. It is the fundamental building block of most SQL procedure statements. You can combine the results of multiple table-expressions with set operators, which creates a query-expression. Use one ORDER BY clause for an entire query-expression. Place a semicolon only at the end of the entire query-expression. A query-expression is often only one SELECT statement or table-expression.

Previous Page | Next Page | Top of Page