yql/essentials/tests/sql/suites/in/in_immediate_subquery.sql


1
2
3
4
5
6

/* postgres can not */
use plato;

select * from Input4 where subkey not in (select key || "0" from Input4) order by key,subkey; 

select * from Input4 where subkey in compact(select key || "0" from Input4) order by key,subkey;