SOQL Query on Opportunity-Account(Master detail)

Question

Account acc;
if(o.AccountId!=null) {
    acc = [select id,GUP_GUID__c,OwnerId 
           from Account 
           where Id = : o.AccountId];
}

List<ECP__c> ecpList = [select id 
                        from ECP__c 
                        where Account__c = :acc.GUP_GUID__c 
                        AND OwnerId= :o.OwnerId 
                        AND Status_Internal__c='Active'];

if(ecpList.size()>0) {
    ECP__c ecp = ecpList[0];
    o.WCSS_ECP__c = ecp.Id;
    update o;
}

Instead of getting the account first from Opportunity, is there a way to get Account out of Opportunity o directly in the ECP__c query(second one)?

Answer 1

as @eric already mentioned, you have 2 options based on from where and how you are getting the Opportunity object that you pass into the method..

1. if you are querying your opportunity before passing into the method, include the field Account.GUP__GUID__c into your query.. something like this

   Opportunity opp = [Select Id, Name, Account.GUP__GUID__c from Opportunity where id = 'yourOppId' limit 1];

2 (a). but if you are calling this method from an opportunity trigger then you cannot directly access related object fields using Trigger.New, So you need to perform the additional query to get the related Account field

2 (b). you can create a custom formula field on the Opportunity to get the GUP__GUID__c field value from Account into the Opportunity so that you can directly access the field