join_using_multiple3.sql 288 B

123456789101112
  1. --!syntax_pg
  2. select foo, q.foo as a1, w.foo as a2, e.foo as a3, r.foo as a4 from
  3. ((select 1 as foo) q
  4. full join
  5. (select 2 as foo) w
  6. using (foo))
  7. full join
  8. ((select 3 as foo) e
  9. full join
  10. (select 4 as foo) r
  11. using (foo))
  12. using(foo) order by foo