How to select an object within a collection?

SQL++
23

Please check this out N1QL subquery in select
In N1QL the join relation ship needs through document key. N1QL doesn’t support join relation ship through different fields in the document.