aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/join/anyjoin_common_nodup.sql
blob: 977215d43a56b81347bbeb57345db197e02c8091 (plain) (blame)
1
2
3
4
5
6
7
8
9
/* syntax version 1 */
PRAGMA DisableSimpleColumns;
use plato;

select * from     Input1 as a right join     Input2 as b on a.k1 = b.k2 order by a.v1, b.v2;
select * from any Input1 as a right join     Input2 as b on a.k1 = b.k2 order by a.v1, b.v2;
select * from     Input1 as a right join any Input2 as b on a.k1 = b.k2 order by a.v1, b.v2;
select * from any Input1 as a right join any Input2 as b on a.k1 = b.k2 order by a.v1, b.v2;