path: root/yql/essentials/tests/sql/suites/pg/join_using9.sql

--!syntax_pg
select c.*, fooo as b from (
    (select 1 as fooo, 1 as x
    union all
    select 1 as fooo, 2 as y) c
    join
    (select 1 as fooo, 3 as xy) d
    using(fooo)) order by x