Command SELECT - SQL FROM Clause Foundation
Specifies the tables and join conditions for an SQL SELECT command.
FROM <cTableName> [AS <cAliasName>] | FROM (<Expression>) [AS <cAliasName>] | FROM (<SubSelectExpression>) [AS <cAliasName>] | FROM JoinType JOIN <cTableName> JoinCondition [AS <cAliasName>] JoinType: INNER | LEFT [OUTER] | RIGHT [OUTER] | FULL [OUTER] JoinCondition: ON <JoinExpression> | USING <cFieldName> [, <cFieldName>] ]
The FROM clause specifies one or more source elements of an SQL SELECT command. In most cases, the <cTableName> syntax is used which specifies the name of a table to be used as an input for the query. However, the results returned by expressions and subselects can also be used as the input for an SQL SELECT. In all cases, an alias name can be specified for the respective source element. Defining an alias allows for unambiguous and easy addressing of the respective element in the SQL SELECT statement, for example, in the column specification.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.