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


1
2
3
4
5
6
7
8
9

PRAGMA DisableSimpleColumns;
/* postgres can not */
/* syntax version 1 */
use plato;
SELECT a.v, b.value
FROM `Input1` VIEW `ksv` AS a
JOIN `Input2` AS b
ON a.k == b.key
ORDER BY a.v;