In the n1ql tutorial there are two tables like product and purchases, I want select the products and their purchases without join but not working:
FROM product p
LEFT NEST purchases ON (META(p).id IN purchases.lineItems.product)
No index available for ANSI nest term purchases
So how you do it ?
remove the code and add the code from the above their: https://query-tutorial.couchbase.com/tutorial/#40