FROM Clause
Variants:
1.
... FROM dbtab [AS alias]
2.
... FROM (dbtabname)
3.
... FROM tabref1 [INNER] JOIN tabref2 ON cond
4.
... FROM tabref1 LEFT [OUTER] JOIN tabref2 ON cond
Additions:
1.
... CLIENT SPECIFIED
2.
... BYPASSING BUFFER
3.
... UP TO n ROWS
Effect
Used in a
SELECT
statement to name the source (
database tables
and
views
) from which the
system is to select data.
Addition 1
... CLIENT SPECIFIED
Effect
Automatic client handling is suspended. This enables you to search all clients in a client-
specific table. The client field is treated as a perfectly normal table field, for which you can
specify conditions in the
WHERE
clause
.
The
CLIENT SPECIFIED
addition must come immediately after the name of the database
table, or, in a
JOIN
, immediately after the last
ON
condition.
Example
To output a list of all customers in client 003: