I have two queries, how can I join both together into one SOQL?
SELECT o.Partner_Account__c, o.id, o.name, o.Account.Id, from Opportunity o
SELECT a.id, a.name from account a where a.id = my_Partner_Account__c
Partner_Account__C is id of Account object, I want to get PartnerAccount id/name in the opportunity query.
Opportunity object has two Account objects, one is a relation o.Account and the other is lookup - o.Partner_Account__C.