yql/essentials/tests/sql/suites/in/in_with_subquery_where.sqlx


1
2
3
4
5
6
7
8
9
10
11
12
13
14

/* postgres can not */
USE plato;
pragma warning("error", "4501");

$subq = (SELECT subkey FROM Input WHERE value = "ddd");

--INSERT INTO Output
SELECT
    key as key,
    "" as subkey,
    "value:" || value as value
FROM Input
WHERE subkey in ($subq)
ORDER BY key