join_using8.sql 163 B

123456
  1. --!syntax_pg
  2. select c.fooo as x, d.fooo as y from (
  3. (select 1 as fooo, 1 as x) c
  4. full join
  5. (select 2 as fooo, 3 as xy) d
  6. using(fooo)) order by x, y