title: MySQL: How to join two tables with some rows that does not match
body: <p>I have two MySQL Tables:</p>
  
  <p>table1:</p>
  
  <pre><code>myTime|foo
  ----------
  00:00 |8
  ----------
  00:10 |6
  ----------
  00:20 |1
  ----------
  00:30 |5
  ----------
  00:40 |3
  ----------
  00:50 |4
  ----------
  </code></pre>
  
  <p>table2:</p>
  
  <pre><code>myTime|bar
  ----------
  00:00 |6
  ----------
  00:10 |10
  ----------
  00:50 |5
  ----------
  </code></pre>
  
  <p>I want to get this result:</p>
  
  <pre><code>myTime|foo|bar
  --------------
  00:00 |8  |6
  -------------
  00:10 |6  |10
  -------------
  00:20 |1  |
  -------------
  00:30 |5  |
  -------------
  00:40 |3  |
  -------------
  00:50 |4  |5
  -------------
  </code></pre>
  
  <p>Despite there are no entries for time = 0:20 - 0:40 in table 2 this rows should not be skiped in the result.</p>