ydb/yt/yql/tests/sql/suites/union_all/union_all_multiin.sql

USE plato;

SELECT * FROM (
    SELECT key, value from Input
    UNION ALL
    SELECT subkey as key, value from Input2
)
ORDER BY key, value
;