Below is my sample:
SELECT f.id as family, c.FirstName AS child, p.GivenName AS pet FROM Families f JOIN c IN f.Children JOIN p IN c.Pets WHERE p.GivenName = 'Fluffy' ORDER BY c.FirstName
Below is my sample:
SELECT f.id as family, c.FirstName AS child, p.GivenName AS pet FROM Families f JOIN c IN f.Children JOIN p IN c.Pets WHERE p.GivenName = 'Fluffy' ORDER BY c.FirstName
"Order-by over correlated collections is not supported" which means that JOIN and Order by clause are not supported
together.
You need to consider changing the data model suits your need.