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 w1, W2 w2, W3 w3
WHERE w1.Key1W1 = w2.Key1W2 AND w1.Key2W2 = w2.Key2W2  AND w1.Key1W1 = w3.Key1W3;