FROM table_spec [ table_alias ] [, [table_spec2 [ table_alias ] [ $omnidex ] ] [[ < LEFT | RIGHT >][ OUTER | CROSS ] ] [ JOIN table_spec2 ] [ ON table_spec1.linkfield = table_spec2.linkfield ] [ <AND | OR> NOT] table_spec.linkfield = table_spec.linkfield ]
The From Datasource can be one of the following:
table_spec | A table using a syntax of [database.]table. |
$OMNIDEX | An internal table automatically created and used for testing consisting of one row and one column. |
(subquery) | A nested subquery. |
JOIN Clause | Joins one or more tables. |