DRAFT

Omnidex SQL: SELECT FROM Clause

QuickLinks Statements Functions OdxSQL
See Also: SELECT statement WHERE clause GROUP BY clause ORDER clause

Description

Syntax

  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 ]

Discussion

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.

Examples

Simple

2nd example