title: SQL Join to return null rows from both left and right table
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/4415109/mysql-full-outer-join-how-do-i-merge-one-column">MySQL: FULL OUTER JOIN - How do I merge one column?</a>  </p>
  </blockquote>
  
  
  
  <p>Real simple question, but have completely confused myself.</p>
  
  <p>Say I have the following tables:</p>
  
  <h1>tbl1</h1>
  
  <p>id - count1<br>
  a  - 7<br>
  b  - 4<br>
  d  - 2 </p>
  
  <h1>tbl2</h1>
  
  <p>id - count2<br>
  a  - 3<br>
  c  - 4   </p>
  
  <p>I want to create a table that gives the following result:</p>
  
  <h1>tbl_temp</h1>
  
  <p>id - count1  - count2<br>
  a  -  7  -  3<br>
  b  - 4  -  null<br>
  c  -  null  -  4<br>
  d  -  2  - null   </p>
  
  <p>What type of join do I need to use?</p>
  
  <p>Cheers,</p>
  
  <p>Ben</p>