ydb/yt/yql/tests/sql/suites/join/three_equalities.sql

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
;