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;