title: SQL - using JOIN while filling missing values with NULL
body: <p>The most related question I looked into was <a href="https://stackoverflow.com/questions/16698106/sql-left-outer-join-to-fill-null">this</a> but sadly I did not get a solution for my problem there.</p>
  
  <p>I have two tables, both have a similar column. The only difference is that one column is missing a few values. I want to join the tables, so that for the missing value in one column, the join will show the missing values.</p>
  
  <p>Ill provide an example since this might be confusing - </p>
  
  <pre><code>table 1            table 2
  ID count           ID count
  1  9               1  2
  2  2               2  1
  3  1
  </code></pre>
  
  <p>I want the result to be</p>
  
  <pre><code>table 3
  ID count2 count1
  1  2      9
  2  1      2
  3  NULL   1
  </code></pre>
  
  <p>However, using <code>LEFT OUTER JOIN</code> I could only achieve the table "table 3" without the row for id 3, because it has no representation in table 2.</p>
  
  <p>Can you help me with my problem?</p>