blob: e93702356438109561553213794f7dc9aabeee89 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
|
PRAGMA FilterPushdownOverJoinOptionalSide;
PRAGMA config.flags("OptimizerFlags", "FuseEquiJoinsInputMultiLabels", "PullUpFlatMapOverJoinMultipleLabels");
SELECT t1.Key1, t1.Key2, t1.Fk1, t1.Value, t2.Key, t2.Value, t3.Value
FROM plato.Input1 AS t1
LEFT JOIN plato.Input2 AS t2
ON t1.Fk1 = t2.Key
INNER JOIN plato.Input3 as t3
ON t1.Fk1 = t3.Key
WHERE t2.Value > 1001;
|
