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


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

/* postgres can not */
use plato;
pragma SimpleColumns;

SELECT *
FROM `Input2` AS a
LEFT SEMI JOIN `Input3` AS b
ON a.value == b.value;

SELECT *
FROM `Input2` AS a
LEFT ONLY JOIN `Input3` AS b
ON a.value == b.value;

SELECT *
FROM `Input2` AS a
RIGHT SEMI JOIN `Input3` AS b
ON a.value == b.value;

SELECT *
FROM `Input2` AS a
RIGHT ONLY JOIN `Input3` AS b
ON a.value == b.value;