blob: 343b8748b7711c6101413caab2bf0d0b7941ab48 (
plain) (
blame)
1
2
3
4
5
6
7
8
|
PRAGMA DisableSimpleColumns;
PRAGMA DisablePullUpFlatMapOverJoin;
use plato;
from (select key, subkey as asubkey, value from Input1) as a
left semi join (select key, 1 as value from Input2) as b using(key)
select a.key, a.asubkey
order by a.key;
|
