yql/essentials/tests/s-expressions/suites/Optimizers/SelfJoinIntersectTab1.sql


1
2
3
4
5

USE plato;

$a = (SELECT key,subkey || "a" as subkey from Input where value < "r");
$b = (SELECT key,subkey || "b" as subkey from Input);
select a.key as k1,a.subkey,b.subkey from Input as a join $b as b using (key);