table-reference

Syntax

table-reference join-type table-reference

ON join-predicate

Semantics

table-reference

is a table-primary or another joined-table.

join-type

is one of the following:

INNER JOIN

LEFT [ OUTER ] JOIN

RIGHT [ OUTER ] JOIN

join-predicate

for an INNER JOIN, an equi-join based on a PRIMARY KEY-FOREIGN KEY constraint relationship between the joined tables.

for an OUTER JOIN: an equi-join based on a PRIMARY KEY-join key relationship between the joined tables that does not involve a FOREIGN KEY constraint.

Notes

A query that uses INNER JOIN syntax in the FROM clause produces the same result set as a query that uses the WHERE clause to state the join-predicate.
The outer table in an OUTER JOIN is the anchor table.
Note to reviewers: "anchor table" may not be the right term. See note in Outer Joins.
Self outer joins are not allowed.

Syntax

{ table-name [ AS ] alias

[ ( column-alias [ , ...] ) ] [ , ...] ]

| ( joined-table ) }

Semantics

table-name	specifies a table in the logical schema. Vertica selects a suitable projection to use.
alias	specifies a temporary name to be used for references to the table.
column-alias	specifies a temporary name to be used for references to the column.
joined-table	specifies an outer join.

table-primary	specifies an optionally qualified table name with optional table aliases, column aliases, and outer joins.
joined-table	specifies an outer join.