I have 2 tables Deal__c and DealProduct__c. They have one to many relation. I want to combine 2 SOQL queries with different where clause:
Select Name, Date_Of_Deal__c, Total_Amount__c from Deal__c where Column1__c = 'something'
for deals above I want to get information about corresponding Deal Products but with a where clause (that differs from where clause above):
Select Product_Name__c, Quantity__c from DealProduct__c where ColumnA__c = 'xyz'
Is there a way to get data from both table using 1 query?