function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Using Workbench to create a Query between Contact and Opportunity.

Can I create a SOQL query saying - show me all those Contacts which have the opportunity. ?


I think i will have to use the OpportunityContactRole table.


Basically I am trying to search for those contacts which do no thave any email, phone but they have opportunity. How can I build such a query. ?

Ritesh AswaneyRitesh Aswaney

Select Id, Name from Contact where Id in (Select ContactId from OpportunityContactRole)