yql/essentials/tests/sql/suites/select_yql/join_cross_2_implicit.yql


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

PRAGMA YqlSelect = 'force';
PRAGMA AnsiImplicitCrossJoin;

SELECT
    a,
    b
FROM (
    VALUES
        (01),
        (02)
) AS x (
    a
)
, (
    VALUES
        (10),
        (20)
) AS y (
    b
);