I’m new to SalesForce and SOQL and was surprised that simple JOIN can become a real problem for me.
There are 2 Tables (Account and Intake__c) that I want to INNER JOIN. The only data I need from Account Table is Client Name (Name).
I was able to run 2 queries separately with no errors.
SELECT a.Id, a.Name FROM Account AS a
SELECT i.Client_Id__c, i.Intake_Id__c, i.Intake_Name__c, i.Intake_Status__c FROM Intake__c AS i
However, when I try to join them, I get the error:
MALFORMED_QUERY: ERROR at Row:1:Column:151 unexpected token: ‘JOIN’
SELECT i.Client_Id__c, a.Name, i.Intake_Id__c, i.Intake_Name__c, i.Intake_Status__c FROM Intake__c AS i JOIN Account AS a ON (i.Client_Id__c = a.Id)
Read more here: Source link