aboutsummaryrefslogblamecommitdiffstats
path: root/yql/essentials/tests/sql/suites/pg/join_using_multiple3.sql
blob: 989b9822bb5a64736158df2a42142298a95f7580 (plain) (tree)
1
2
3
4
5
6
7
8
9
10
11
12










                                                                   
--!syntax_pg
select foo, q.foo as a1, w.foo as a2, e.foo as a3, r.foo as a4 from
    ((select 1 as foo) q
     full join
     (select 2 as foo) w
     using (foo))
    full join
    ((select 3 as foo) e
     full join
     (select 4 as foo) r
     using (foo))
    using(foo) order by foo