Is it possible to access the children of a parents record using SOQL. For example, from Opportunities I can access the Account details (the parent):
SELECT Id, Name, Account.Id, Account.Name FROM Opportunity
and from Accounts I can access the Contacts (the children):
SELECT Id, Name, (SELECT Id FROM Contacts) FROM Account
but can I access the Contacts from the Opportunity? I'd like to use something like this:
SELECT Id, Name, Account.Id, Account.Name, (SELECT Id FROM Account.Contacts) FROM Opportunity
I know I could use two queries to get the information, but I'd like to be able to do it from a single query.