I have 3 custom objects

1. Organization\_\_c
2. School\_\_c
3. Student\_\_c

**The objects are related like below:**

* Object Organization\_\_c has a lookup field School\_\_c which is a lookup on the object School\_\_c.
* Object School and Student has a master detail relationship where School is parent object and Student is child object.

I actually need to write a SOQL query on the Organization object to get the list of organizations, and in this query itself I have to get the details of the School lookup record and also all the related Student child records of the School.

I am able to write query for getting the Organization and its lookup School record like below:

```
Select Id, Name, School__r.Id, School__r.Name From Organization__c

```

*Is there any way by which I can modify the above query to also get all the Student child records under the School (School is the lookup on Organization). I basically need a single query which can get the list Organization records, Each organization record returned should also have details of its lookup School record and also the Student child records under the School. ?*

Any help would be appreciated