from-clause

The FROM clause specifies an intermediate result table.

Read syntax diagramSkip visual syntax diagramFROM ,table-reference

If only one table-reference is specified, the intermediate result table is the result of that table-reference. If more than one table-reference is specified, the intermediate result table consists of all possible combinations of the rows of the specified table-reference (the Cartesian product). Each row of the result is a row from the first table-reference concatenated with a row from the second table-reference, concatenated in turn with a row from the third, and so on. The number of rows in the result is the product of the number of rows in all the individual table references. For a description of table-reference, see table-reference.