title: Full Outer Join / COALESCE
body: <p>I would like to get some experts advice </p>
  
  <p>I have 2 tables Table1 and Table2 </p>
  
  <p>Table 1 </p>
  
  <pre><code>ID  DATE         SALEPRICE
  
  1   05/12/17     $10
  6   04/12/17     $11
  3   03/12/17     $12
  4   02/12/17     $13
  </code></pre>
  
  <p>Table 2 </p>
  
  <pre><code>ID  DATE         REGULARPRICE
  
  1   07/12/17     $20
  2   08/12/17     $21
  3   09/12/17     $22
  4   10/12/17     $23
  </code></pre>
  
  <p>Result Table</p>
  
  <pre><code>ID  SALEDATE         SALEPRICE REGULARPRICE   REGULARPRICEDATE
  
  1   05/12/17          $10       $20           07/12/17
  6   04/12/17          $11         
  3   03/12/17          $12       $22           09/12/17
  4   02/12/17          $13       $23           10/12/17
  2                               $21           08/12/17
  </code></pre>
  
  <p>I need entries from both the tables ..If i have a match of id from both the tables then i want to get the record in a single row ..</p>
  
  <p>I thought of using the Union but the results are not correct  - Below are my union results</p>
  
  <pre><code>1   05/12/17          $10       null          null
  1   null              null      $20           07/12/17
  6   04/12/17          $11       null          null  
  3   null              null      $22           09/12/17
  3   03/12/17          $12       null          null  
  4   02/12/17          $13       null              null
  4   null              null      $23           10/12/17
  </code></pre>
  
  <p>Do i have to use Full Outer Join and COALESCE to get the desired results</p>
  
  <p>Thanks in advance</p>