List in Where clause

SQL++
1

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?

2

Alright solved this, my inner query would return:
[
[
“myidHere”
]
]
So i used ARRAY_FLATTEN to solve this

1 Like