I'm very new with Salesforce. I've been reading this page trying to figure out how to do joins. All the objects were created before I jumped on this project.
I have one custom object called : Person_Project_Junction__c and another one called Contact.
My query looks like this:
SELECT
Person_Project_Junction__c.Id,
Person_Project_Junction__c.Person_First_Name__c,
Person_Project_Junction__c.Person_Last_Name__c
FROM
Person_Project_Junction__c
I need to access a field in the Contact object called Industry__c
. I tried doing this query:
SELECT
Person_Project_Junction__c.Id,
Person_Project_Junction__c.Person_First_Name__c,
Person_Project_Junction__c.Person_Last_Name__c,
(SELECT Industry__c FROM Contact)
FROM
Person_Project_Junction__c
But of course, it doesnt work. How would I be able to do this join? Thanks!