Work on this feature has started. Will update here when this becomes generally available.
Thank you for your suggestion and votes.
For applications that require cross document join, please consider the Gremlin API: https://docs.microsoft.com/en-us/azure/cosmos-db/create-graph-dotnet, which has primitives for joins, traversals, and other graph operations.
We are evaluating expanding the SQL grammar to support graph functionality, which will provide the ability to perform cross-document JOINs. Please upvote this item to help us prioritize this work.Fernando Romano commented
Any Update on this subject? Thanks.
This feature is currently in active development. We will update this item to complete once it has shipped so those voting/commenting will be notified.
Thank you for your patience.Fernando Romano commented
It's possible to have an ETA for this feature. We need to make some decisions.