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


1
2
3
4
5
6
7
8
9

PRAGMA YqlSelect = 'force';

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

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