join_using2.sql 175 B

12345678
  1. --!syntax_pg
  2. select * from (
  3. (select 1 as fooo, 1 as x
  4. union all
  5. select 1 as fooo, 2 as y) c
  6. join
  7. (select 1 as fooo, 3 as xy) d
  8. using(fooo)) order by x