select_join_right_one.sql 412 B

12345678910111213141516
  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 = 1;
  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 = 0;
  8. select * from (values (1,2),(3,4)) as a(x,y)
  9. right join (values (1,2),(2,5)) as b(u,v)
  10. on b.u = 1;
  11. select * from (values (1,2),(3,4)) as a(x,y)
  12. right join (values (1,2),(2,5)) as b(u,v)
  13. on b.u = 0;