yql/essentials/tests/sql/suites/pg/select_join_left_equi.sql


1
2
3
4
5
6
7
8

--!syntax_pg
select * from (values (1,2),(3,4)) as a(x,y)
left join (values (1,2),(2,5)) as b(u,v)
on a.x = b.u;

select * from (values (1,2),(3,4)) as a(x,y)
left join (values (1,2),(2,5)) as b(u,v)
on a.x = b.u and b.v = a.y;