letting does not support chained correlated subqueries

select join_yr

from default d0

group by join_yr

letting usekeys=(select raw meta(d1).id from default d1 order by meta(d1).id limit 10),

            aa=(select raw join_yr from default d2 use keys usekeys)

reuturns:
[

{ "code": 4210, "msg": "Expression must be a group key or aggregate: (select raw (`d2`.`join_yr`) from `default` as `d2` use keys `usekeys`)", "query_from_user": "select join_yr from default d0 group by join_yr letting usekeys=(select raw meta(d1).id from default d1 order by meta(d1).id limit 10),aa=(select raw join_yr from default d2 use keys usekeys)" }

]