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.

Chapter Contents
Previous
Next
Top of Page