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)
|