JOINS

Joins provide a method to query data from more than one object. The joined objects, or tables, are joined based on a relationship defined in the query.

Compass queries supports joins for different object formats. You can define a query joining data from JSON objects and DSV objects.

SELECT object1.property1, object1.property2, object2.property1, object2.prop erty2, object2.property3 
FROM object1 
[ INNER JOIN | OUTER JOIN | JOIN | LEFT INNER JOIN | LEFT OUTER JOIN | 
RIGHT JOIN | CROSS JOIN] object2 
ON object1.property1=object2.property1