List in Where clause

Hello all,

I am trying to achieve something like the following

select *
from myBucket
where parentId = (Inner query)

The inner query will return a list of id’s. I have tried where parentId IN (inner query) but also no luck, what is the right approach?

Alright solved this, my inner query would return:
So i used ARRAY_FLATTEN to solve this

1 Like