blob: a7c8302df95bc088090731d981c3e6ef8f5b72e5 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
PRAGMA DisableSimpleColumns;
PRAGMA DisablePullUpFlatMapOverJoin;
use plato;
$one = (select key, 1 as subkey, value from Input1);
$two = (select key, value from Input2);
$three = (select key, value, 2 as subkey from Input3);
from $one as a
cross join $two as b
left join $three as c on (c.key = a.key and c.value = b.value)
select * order by a.key,a.subkey,b.key,b.value
|
