union_all_multiin.sql « union_all « suites « sql « tests « essentials « yql - ydb - Mirror of YDB github repos

about summary refs log tree commit diff stats

path: root/yql/essentials/tests/sql/suites/union_all/union_all_multiin.sql

blob: 284528b526b8e0dab473538f2ca93f9605df320f (plain) (blame)

USE plato;

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