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?

List in Where clause

CouchPatata August 3, 2020, 11:59am 2

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

1 Like

Topic		Replies	Views
[*] and IN in the WHERE clause SQL++	11	23322	November 13, 2020
How to use where in for multiple items? SQL++	1	1655	February 19, 2016
Search an array in the WHERE clause SQL++	2	1766	February 13, 2019
How to subquery in where clause SQL++ n1ql	2	2336	October 14, 2016
`where` condition isn't working properly SQL++	1	411	June 28, 2022