I am attempting to create a query with the objects
Opportunity has parent-child relationships with both
Prior_Qualifications__c. I want to be able to query only information with valid
Courses__c records, so that I can disregard any results returned with valid
Opportunity object information, but no
Courses__c information. Is there a way to do this? Am I able to make a query such that:
Select Id, (Select Course_Name__c from Courses__r) from Opportunity where Courses__r.Course_Name__c != ''
I know that this isn't a valid query... but can I do something like this?