SOQL Get Name from nested SELECT statement

Question

I have an SOQL query that is grabbing information from an Opportunity in Salesforce and then grabbing the ContactID of a related contact role. It is only displaying opportunities that have a different child object of a certain type. I would like to extract and display the name of the contact role in my table. Suggestions?

SELECT ID, Name,

(SELECT contactID
FROM opportunitycontactroles
WHERE IsPrimary = TRUE)

FROM Opportunity

WHERE ID IN

(SELECT opportunity_ID FROM 
opportunity_child WHERE 
opportunity_child_picklist = 'Specific Item')

I would like to get the 'Name' field from the contactID found from the Opp. Contact Roles table and display it with the Opportunity ID as well.

superfell superfell · Accepted Answer · 2014-06-09T16:20:34

You can follow the contact relationship in the subquery, e.g.

SELECT ID, Name,

(SELECT contactId, contact.name
FROM opportunitycontactroles
WHERE IsPrimary = TRUE)

FROM Opportunity

WHERE ID IN

(SELECT opportunity_ID FROM 
opportunity_child WHERE 
opportunity_child_picklist = 'Specific Item')

SOQL Get Name from nested SELECT statement

1 Answers