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. |