+ Start a Discussion

Nested SOQL Queries (more than 1 level Parent-to-child queries)

Hi, Folks!


Does anybody know how to make more than 1 level nested Parent-to-Child query?

As I know there is a standard limitations for parent-to-child queries: "In each specified relationship, only one level of parent-to-child relationship can be specified in a query."

Sure I can provide some additional classes to solve the problem, but maybe somebody knows another way?

(kind of how to make additional request for query resulds:


            Select Name, c.Conference__r.Id, c.Conference__c, c.Comapny_Contact__r.FirstName,

            (Select Name From PC_Track__r)  

            From cmp_Participating_Company__c c

            Where c.Conference__r.Id = 'a00A0000000q5nK'



        for (cmp_Participating_Company__c company : companiesList)


            for (cmp_Meeting_Track__c track : company.PC_Track__r)


                track.Meeting_Track__r = [Select Name From cmp_Meeting__c];



Vidya BhandaryVidya Bhandary
Did you finally get an answer to this query ? I tried a similar type of query in the editor and got an error - SOQL statements cannot query aggregate relationships more than 1 level away from the root entity object.