summaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/select_yql/join_implicit_using_left.yql
blob: 5f144c5ad907ac35e952ad2405589eea5a360cee (plain) (blame)
1
2
3
4
5
PRAGMA YqlSelect = 'force';

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