I’ve read through the docs but am not able to see how we can “inner join” 2 object stores in a query.
For example, we have 2 independent object stores - DataSets and DataOrders:
id, colA, colB
id, DataSetID, colX, colY
I’d like to write a single query to join DataSets onto DataOrders via the “DataOrder.DataSetID == DataSet.id”
so I can get a full result set:
DataSet.id, colA, colB, DataOrder.id, DataSetID, colX, colY
Also - we are using React Moralis - https://github.com/MoralisWeb3/react-moralis#usemoralisquery
Any help will be appreciated.