Join Example: Comma-Separated Syntax

An example of a complex join using the comma separated syntax.

This join is a complex join of three windows using the comma-separated join syntax. The WHERE clause specifies the conditions on which records are joined.

CREATE OUTPUT WINDOW OW4
PRIMARY KEY DEDUCED
AS SELECT W1.*, W2.*, W3.*
FROM W1, W2, W3
WHERE W1.Key1W1 = W2.Key1W2 AND W1.Key2W1 = W2.Key2W2  AND W1.Key1W1 = W3.Key1W3;
Related concepts
Key Field Rules
Related reference
Join Examples: ANSI Syntax