5.26Your SQL instincts can hurt you

SQL brain:

SELECT *
FROM Contact c
JOIN Account a
ON c.AccountId = a.Id

SOQL brain:

SELECT
    Id,
    FirstName,
    Account.Name
FROM Contact

Salesforce relationship traversal is the key mental shift.