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


1
2
3
4
5
6
7
8
9
10
11
12

PRAGMA DisableSimpleColumns;
USE plato;
SELECT * FROM
    Input1 AS A
JOIN
    Input2 AS B
ON
    A.key == B.key AND
    (cast(A.subkey AS int) + 1 == cast(B.subkey AS int)) AND
    A.value == B.value
ORDER BY A.key
;