You need to sign in to do that
Don't have an account?
Sumant Kuchipudi
How can I get parent's parent record fields from a child query? Is it possible? like join in SQL
How can I get parent's parent record fields from a child query? Is it possible? like join in SQL
The following is relationship with objects
Book__c has lookup field Shop__c
Shop__c has lookup field Account
Account has a externalID
I want to get Account's externalID with the Book__c ID.
to Continue my question, in SQL I'll use to get parent's parent record field with this
The following is relationship with objects
Book__c has lookup field Shop__c
Shop__c has lookup field Account
Account has a externalID
I want to get Account's externalID with the Book__c ID.
to Continue my question, in SQL I'll use to get parent's parent record field with this
select acc.relID from BOA boa, Contact con, Account acc where acc.accID = con.accID and con.conID = boa.conID and boa.boaID='ABC12342323'Please advice
You can try something like this:
I hope this helps.
All Answers
You can try something like this:
I hope this helps.
Yes, it helped
I was able to get CustomObject-->Opportunity-->Account--ExternalID as well which I want..
Thanks for the clue..