join_brackets1.sql 184 B

1234567891011
  1. --!syntax_pg
  2. select * from
  3. (select 1 as foo) a
  4. join
  5. (select 2 as bar) b
  6. on a.foo + 1= b.bar
  7. join
  8. ((select 3 as x) c
  9. join
  10. (select 4 as y) d
  11. on c.x=d.y-1) on a.foo=c.x-2 and b.bar=d.y-2