blob: fe7fdeea48ca2d00e4d213045a26fe8c40ff4b14 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
|
PRAGMA FilterPushdownOverJoinOptionalSide;
SELECT t1.Key1, t1.Key2, t1.Fk1, t1.Value, t2.Key, t2.Value, t3.Value
FROM plato.Input1 AS t1
CROSS JOIN plato.Input3 AS t3
LEFT JOIN plato.Input2 AS t2
ON t1.Fk1 = t2.Key
WHERE t2.Value > 1001;
|
