Dave KIlby
asked on
Salesforce SOQL 3 Objects
I would like to create a SOQL pulling data from 3 objects - below are the individual queries
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.Contr act__c
is this possible to pull all data in one query and if so how?
Thanks
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
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.Contr
is this possible to pull all data in one query and if so how?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.