Relationship Queries in SOQL | Parent to Child | Learn Salesforce Development

[@DharmendraKumar-wp4ur]

Suppose we have two custom accounts Object Parent and Child, and we want to fetch name of child account from parent account..what is the query for that ??

[@shubhammali8]

select id,(select name__c from childs__r) from parent__C; let me know if this is working.

[@akshayphadnis]

And how to fetch data from the inner query? Maybe I want to store inner query data into some variable

[@megheshshenoy]

List Med = new List(); Med = [SELECT id, (SELECT Review_Submission_Date__c, Comments__c, Media__c, Member__c, Rating__c FROM Reviews__r) FROM Media__c WHERE id =:recId LIMIT 50]; List Rev = new List(); //This record will now have the correct type to be added to the list Rev.add(Med[0].Reviews__r[0]);

[@KumarNaveennaveen]

If have created a report and report type contains Accounts, Custom object lets say B. I am filtering in report using Account record type and record type from B. COULD YOU PLEASE TELL ME HOW CAN WE WRITE A SOQL QUERY FOR THIS?? PLEASE

[@megheshshenoy]

SELECT Id,(SELECT Id from ChildrelationshipName WHERE RecordTypeId='recordTypeId') FROM Account where RecordTypeId=''recordTypId'

[@shivanibabbar8232]

so many ads in your videos , after every 2-3 mins there are ads it becomes irritating sometimes pls remove it only add it in the beginning and end

[@karanammaheedhar3595]

Is their any possible way to Get child fields from parent obj using single select keyword in SOQL

[@megheshshenoy]

Select id, (Select Name__c from childs__r) from parent__c

[@ramireddygarivinaykumarred7261]

Bro We want interview trigger scenarios Please do it bro

[@SalesforceHulk]

It will uploaded very soon.

[@ramireddygarivinaykumarred7261]

Thanks @@SalesforceHulk

[@masulusravani8356]

🙌🙌