You need to sign in to do that
Don't have an account?

SOQL to find all the opportunities related to a Contact
I have a contact and I want to find all the Opportunities related to this contact's parent Account. Is there any single SOQL query to achieve this?
Try with below query in your developer console.
If this helps, Please mark it as best answer.
Thanks!!
FIrst fetch AccountId from Contact that's you have after that use below query :
if you need any assistanse, Please let me know!!
Kindly mark my solution as the best answer if it helps you.
Thanks
Mukesh
Your answer is correct but I was looking for a single SOQL query. Thanks for looking into this though.
If you want to fetch All opportunities from Account then you need a sub query that's i have shred with you.
if you need any assistanse, Please let me know!!
Kindly mark my solution as the best answer if it helps you.
Thanks
Mukesh