You need to sign in to do that
Don't have an account?
SOQL Relationship question
Hi,
I have a custom field on my Account object called CSR__c for a Customer Service Rep which is related to User. If I want two emails, one for the CSR__c and one for the Account Owner, I do something like this to get what I need:
select Id, Name, Owner.Email, CSR__r.Email from Account where ...
However, today, I would like to select this information about a Contact's Account in one statement. I would really love to be able to write:
select Id, Firstname, Lastname, Account.Owner.Email, Account.CSR__r.Email from Contact where ....
Is this possible to write somehow, using one query? Am I close at least?
Thanks!!