FROM clause
532
FROM clause
Use this statement to specify the database tables or views involved in a
SELECT or UPDATE statement.
… FROM
table-expression
, …
table-expression
:
table-spec
|
table-expression
join-type
table-spec
[ ON
condition
]
| (
table-expression
, … )
table-spec
:
[
userid
.]
table-name
[ [AS]
correlation-name
]
|
select-statement
[ AS ]
correlation-name
[ (
column-name,
… ) ]
join-type
:
CROSS JOIN
| [ NATURAL | KEY ] JOIN
| [ NATURAL | KEY ] INNER JOIN
| [ NATURAL | KEY ] LEFT OUTER JOIN
| [ NATURAL | KEY ] RIGHT OUTER JOIN
None.
None.
"DELETE statement" on page 496
"SELECT statement" on page 601
"UPDATE statement" on page 637
"Joins: Retrieving Data from Several Tables" on page 195 of the book ASA
User’s Guide
The SELECT, UPDATE, and DELETE statements require a table list, to
specify which tables will be used by the statement.
Views and derived tables
Although this description refers to tables, it applies to views and derived
tables unless otherwise noted.
The FROM table list creates a result set consisting of all the columns from
all the tables specified. Initially, all combinations of rows in the component
tables are in the result set, and the number of combinations is usually
reduced by join conditions and/or WHERE conditions.
Tables owned by a different user can be qualified by specifying the user ID.
Tables owned by groups to which the current user belongs will be found by
default without specifying the user ID (see "Referring to tables owned by
groups" on page 757 of the book ASA User’s Guide).
Function
Syntax
Permissions
Side effects
See also
Description
To Next Page
Loading...