yql/essentials/tests/sql/suites/weak_field/weak_field_join_no_src.yql


1
2
3
4
5
6
7

use plato;

SELECT
  i1.subkey as sk,
  WeakField(value1, "String", "funny") as v1, -- no idea to check value1 from i1._other or i2._other
  WeakField(value2, "String", "bunny") as v2
FROM Input1 as i1 join Input2 as i2 USING(subkey) ORDER BY sk