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


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

PRAGMA DisableSimpleColumns;
/* postgres can not */
USE plato;
SELECT
    a.key AS a_key,
    b.key AS b_key,
    a.value AS a_value,
    b.value AS b_value
FROM
    `test_join_1` AS a
FULL JOIN
    `test_join_2` AS b
ON
    a.key == b.subkey
ORDER BY
    b_key, a_key
LIMIT 25
;