select_join_right_equi.sql 230 B

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