Link to home
Start Free TrialLog in
Avatar of Dave KIlby
Dave KIlbyFlag for Canada

asked on

Salesforce SOQL 3 Objects

I would like to create a SOQL pulling data from 3 objects - below are the individual queries

SELECT Id,Name FROM Contract__c

SELECT Contract_ID__c,Make__c,Model_Year__c,Model__c,Vin_Ser__c FROM Asset__c

SELECT Address__c,Contract__c FROM Customer_Contract__c

Open in new window


the link between Contract__c and Asset__c  is Contract__c.ID to Asset__c.Contract_ID__c

the link between Contract__c and Customer_Contract__c is Contract__c.ID to Customer_Contract__c.Contract__c

is this possible to pull all data in one query and if so how?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Rob
Rob
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial