+ 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 Aswaney
Select Id, Name from Contact where Id in (Select ContactId from OpportunityContactRole)

Need an account? Sign Up

Have an account? Sign In