title: MySQL SELECT JOIN with empty row returns
body: <p>I have the following MySQL tables:</p>
  
  <p>[users]</p>
  
  <pre><code>| id | name    |
  |----|---------|
  | 1  | John    |
  | 2  | Anna    |
  | 3  | Peter   |
  </code></pre>
  
  <p>[times]</p>
  
  <pre><code>| user_ID | date       | time   |
  |---------|------------|--------|
  | 1       | 2020-03-20 | 07:00  |
  | 1       | 2020-03-21 | 08:00  |
  | 3       | 2020-03-22 | 09:00  |
  </code></pre>
  
  <p>my query look like:</p>
  
  <pre><code>SELECT name, date, time 
  FROM users 
  INNER JOIN times ON times.user_ID = users.id 
  WHERE date = '2020-03-22';
  </code></pre>
  
  <p>what i get is:</p>
  
  <pre><code>| name    | date       | time   |
  |---------|------------|--------|
  | Peter   | 2020-03-22 | 09:00  |
  </code></pre>
  
  <p>what i want is:</p>
  
  <pre><code>| name    | date       | time   |
  |---------|------------|--------|
  | John    |            |        |
  | Anna    |            |        |
  | Peter   | 2020-03-22 | 09:00  |
  </code></pre>
  
  <p>is there a way to join non existent lines (not fields!) in the times table with the users table?</p>