How to JOIN 2 Tables in SalesForce (SOQL)

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.

Account:

SELECT 

     a.Id, 
     a.Name

FROM Account AS a

Intake__c:

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)