I would like to join two collections in my java API code. From my understanding when using TQuery.newInstance(query), your query uses the X-Query language. I was hoping to join from two different collections but all I am finding is the capability to join to documents in one collection unfortunately using XQuery and not X-Query.
Any ideas how I can solve this?