join_using_multiple1.sql 221 B

123456789
  1. --!syntax_pg
  2. select a.fooo as x, b.fooo as y, c.fooo as z, fooo from (
  3. (select 1 as fooo) a
  4. full join
  5. (select 2 as fooo) b
  6. using (fooo)
  7. full join
  8. (select 3 as fooo) c
  9. using(fooo)) order by fooo