BookatlasTwo-Day MuleSoft → Salesforce Bootcamp
84 / 278 · Module 5 — Salesforce Data Model + SOQL · filtered: code← prev⊞ allnext →

5.21Filtering using the parent

Suppose interviewer says:

Get all Contacts whose Account is in Florida.

SELECT
    Id,
    FirstName,
    LastName,
    Email,
    Account.Name
FROM Contact
WHERE Account.BillingState = 'FL'

This is the answer I want you to immediately recognize.

No:

JOIN Account...

Instead:

Contact → Account relationship