I need to pull all opp records where a field on the partner Account is blank.
In our Account object, we have 'Partner_Account__c' field which maps back to the Id field of the Account.
I have the Opp Id and I only need to pull it if field A on the Partner Account record is blank. Does this make sense?
Can I write this in a SOQL statement? I know that if you pull the Opportunity object, it pulls all related objects such as Account but in this case. If this was in SQL, I would write a recursive query.