I have custom junction object which has Master-detail relation ship with contact. Generally we have relation ship field that contain contact name in junction object.but I want write soql query to fetch recods from child object where contact owner is 'ram'.

1 Answer 1


This page from the Force.com SOQL and SOSL Reference should help.

When you use a child-to-parent relationship, you can use dot notation:

SELECT Id, FirstName__c, Mother_of_Child__r.FirstName__c
FROM Daughter__c
WHERE Mother_of_Child__r.LastName__c LIKE 'C%'  

In your case the Mother_of_Child__r.LastName__c LIKE 'C%' would be something like Contact__r.Owner.Name = 'ram' the Contact__r depends on the API Name of your relationship field.


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .