summaryrefslogtreecommitdiffstats
path: root/yt/yql/tests/sql/suites/join/star_join_with_diff_complex_key.yql
blob: 94408a517ece8e25e466b0f3ec6c9ef0ad1e7ac6 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
/* syntax version 1 */
use plato;
pragma yt.JoinEnableStarJoin="true";


select *
from Input1 as a
join any Input2 as b on a.k1 = b.k2 AND a.v1 = b.v2
join any Input3 as c on a.k1 = c.k3 AND a.v1 = c.v3
left join Input4 as d on (c.v3, c.u3) = (d.v4, d.u4)