I want to get a list of Opportunity (Standard Object) Records, which is the Master Object, which have no associated Quotes__c (Custom Object), which is the Child Object.


Making some assumptions about your data model here, but try this:

SELECT Id, Name FROM Opportunity WHERE Id NOT IN (SELECT Opportunity__c FROM Quote__c)
| improve this answer | |
  • 1
    Please mark it as an answer then ... – user735 Feb 5 '15 at 21:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.