yql/essentials/tests/sql/suites/join/three_equalities_paren.sql


1
2
3
4
5
6
7
8
9
10
11

PRAGMA DisableSimpleColumns;
USE plato;
SELECT * FROM
    Input2 AS A
JOIN
    Input4 AS B
ON
    (A.key == B.key) AND
    (A.subkey == B.subkey) AND
    (A.value == B.value)
;