+ Start a Discussion
sudha76sudha76 

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)