You need to sign in to do that
Don't have an account?
![Yukinon Yukinon](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
3 Lookup Relationship SOQL Query
I want to get the data from opportunity product and the opportunity name where that product is currently in but I can only get the opportunity Id since opportunity is in a lookup relationship with account.
Any tips on how can I get OpportunityProduct.Name and Opportunity.Name from Opportunity, Opportunity Product, and Account Object?
Any tips on how can I get OpportunityProduct.Name and Opportunity.Name from Opportunity, Opportunity Product, and Account Object?
try with below query.
If this helps, Please mark it as best answer.
Thanks!!