yql/essentials/tests/sql/suites/select_yql/join_implicit_using_3.yql


1
2
3
4
5

PRAGMA YqlSelect = 'force';

SELECT * FROM (VALUES (1, 2, 4)) AS x (a, b, cx)
JOIN (VALUES (1, 2, 3)) AS y (a, b, cy)
ON x.a == y.a AND x.b == y.b AND x.cx == y.cy;