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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

PRAGMA DisableSimpleColumns;
use plato;

SELECT
    A.key,
    B.subkey
FROM
    Input2 AS A
LEFT JOIN
    (
        SELECT
            key,
            CAST(key AS INT) AS subkey
        FROM
            Input3
    ) AS B
ON
    A.key == B.key
ORDER BY A.key
;