yql/essentials/tests/sql/suites/join/yql-12022.sql


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

/* postgres can not */
/* syntax version 1 */
USE plato;

DEFINE SUBQUERY $sub($name) AS
    SELECT * FROM $name
END DEFINE;

SELECT a.key
FROM $sub("Input") AS a
INNER JOIN Input AS b
ON  a.key = b.key
WHERE JoinTableRow().`a.subkey` == "wat"