I want to write a soql query , My scenario is as follows. I have three objects objectA,objectB,objectC. objectA is the parent object for both objectB,objectC.
- objectA - objectB (Master-detail relationship)
- objectA - objectC (Master-detail relationship)`
ObjectB has two fields:
ObjectC has a field:
Now i want to retrieve records with date__c in objectC those were in between start_date__c and end_date__c of objectB. how can i achieve such functionality .