ON Clause: Join Syntax

Specifies join conditions for syntax using JOIN terminology.

Syntax

ON source1.columnA = source2.columnB [AND...]

Components

`source`	The names of the sources in the FROM clause.
`column`	The name of the column from a particular source. Use `AND` when multiple column comparisons are specified. `OR` expressions are not supported.

Usage

This form of the ON clause is required for outer and inner joins. It must consist of one or more simple comparisons, comparing a column in one data source with a column in another data source.

source1 and source2 refers to the sources (streams, windows, or delta streams) in the FROM clause. If aliases are used in the FROM clause, use the aliases rather than the actual source names.

Restrictions

Join conditions are limited to comparisons between columns in the two data sources of the join. The comparison cannot specify a literal value, or compare two columns in the same data source.