Hello Team,
I want to add one more field to the below SOQL.  This field  "Name" is coming from a different Entity. Not sure how can I go about this

Field to add: Name   , Table: TBC_Verticals__c

SELECT Name,
    (SELECT UnitPrice FROM OpportunitylineItems) ,
    (SELECT Revenue__c FROM Opportunity_Line_Item_facts__r) ,
    FROM opportunity

  

I got these tables in Salesforce 
Opportunity with  Drop ID  and MBK Key  ( along with other fields)
&
Opportunity_lineitem  with IO Key, Drop ID  

Drop ID is common across and I need to tweak the below SOQL to bring  MDK Code from Opportunity. Is this possible?

Select
IO Key, Drop ID
From Opportunity_linitem

Hello Team,
I want to add one more field to the below SOQL.  This field  "Name" is coming from a different Entity. Not sure how can I go about this

Field to add: Name   , Table: TBC_Verticals__c

SELECT Name,
    (SELECT UnitPrice FROM OpportunitylineItems) ,
    (SELECT Revenue__c FROM Opportunity_Line_Item_facts__r) ,
    FROM opportunity

  

I got these tables in Salesforce 
Opportunity with  Drop ID  and MBK Key  ( along with other fields)
&
Opportunity_lineitem  with IO Key, Drop ID  

Drop ID is common across and I need to tweak the below SOQL to bring  MDK Code from Opportunity. Is this possible?

Select
IO Key, Drop ID
From Opportunity_linitem