FROM deals d JOIN accounts a ON a.account_id = d.account_id pairs each deal with its account through the shared key. JOIN (inner) keeps only rows that match on both sides; LEFT JOIN keeps every row from the left table and fills the right side with NULL when there's no match. Aliases (d, a) keep column names short and unambiguous.