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


1
2
3
4
5
6
7

PRAGMA DisableSimpleColumns;
/* postgres can not */
SELECT A.*, C.subkey as goal,B.*
FROM plato.A
JOIN plato.B ON A.key == B.key
JOIN plato.C ON B.subkey == C.subkey
ORDER BY A.key;