yql/essentials/tests/sql/suites/join/inner_with_select.sql


1
2
3
4
5
6
7
8
9

PRAGMA DisableSimpleColumns;
select
    Input1.key as key,
    Input1.subkey as subkey,
    selected.value as value
from plato.Input1
inner join (select key, value || value as value from plato.Input3) as selected
    using (key)
order by key desc;