You need to sign in to do that
Don't have an account?
lijin Dev
How to lookup from another Salesforce Table within SOQL?
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
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
select id, Opportunity.Procedure_Distal_Lead_Placement__c from OpportunityLineItem where Opportunity.MDKCode IN ('0001','0011','0111') AND other where condition as well.
Please feel free to reach in case still not done.
and please mark it as best answer as well.
Regards
Arjun Soni
All Answers
if no please clarify your question.
Select id,MDKCode ,(select IO Key, Drop ID From Opportunity_linitem) from Opportunity where group by MDKCode
select id, Opportunity.Procedure_Distal_Lead_Placement__c from OpportunityLineItem where Opportunity.MDKCode IN ('0001','0011','0111') AND other where condition as well.
Please feel free to reach in case still not done.
and please mark it as best answer as well.
Regards
Arjun Soni