select_join_left.sql « pg « suites « sql « tests « essentials « yql - ydb - Mirror of YDB github repos

about summary refs log tree commit diff stats

path: root/yql/essentials/tests/sql/suites/pg/select_join_left.sql

blob: 4190c29e5e90f019dff8700bddb74a7074a33185 (plain) (blame)

1
2
3

--!syntax_pg
select * from (select 1 as x ) u left join (select 1 as y) v on u.x=v.y;
select * from (select 1 as x ) u left join (select 2 as y) v on u.x=v.y;