title: MySQL inner join help - want to include rows where there is no match
body: <p>I have  a few tables I am joining in a look-up.</p>
  
  <p>(PET)</p>
  
  <pre><code>| id | owner_id |  pet_name   | size |
  --------------------------------------
  | 1  |    1     |   Sparky    |  L   |
  | 2  |    1     |    Spot     |  L   |
  | 3  |    3     |   FooFoo    |  M   |
  | 4  |    3     |    Barky    |  L   |
  | 5  |    3     |    Jeb      |  S   |
  </code></pre>
  
  <p>(OWNER)</p>
  
  <pre><code>| id |  owner_name  |
  --------------------
  | 1  |    Jeff      |
  | 2  |   (Kathy)    |
  | 3  |    Tom       |
  </code></pre>
  
  <p>When I do an inner join like this:</p>
  
  <pre><code>SELECT 
  
  OWNER.id, OWNER.owner_name, PET.pet_name, PET.size
  
  FROM OWNER
  
  INNER JOIN PET ON PET.owner_id = OWNER.id
  </code></pre>
  
  <p>I get a result like this:</p>
  
  <pre><code>| id |  owner_name  |  pet_name   | size |
  ------------------------------------------
  | 1  |     Jeff     |   Sparky    |  L   |
  | 1  |     Jeff     |    Spot     |  L   |
  | 3  |     Tom      |   FooFoo    |  M   |
  | 3  |     Tom      |    Barky    |  L   |
  | 3  |     Tom      |    Jeb      |  S   |
  </code></pre>
  
  <p><strong>Kathy</strong> is not in the result. I understand why. But I want Kathy to be in the result.
  I want all owners to show up regardless of if they have a pet or not - and the ones that do merge as they have with this join.</p>
  
  <p>How do I get all of the OWNER table to display all owners in a join with the PET table - regardless of if they have a pet in PET table?</p>
  
  <p>Thanks everyone :)</p>