title: Join two different columns from two different tables
body: <p>i have two temporary table 
  Table 1</p>
  
  <pre><code> ID1         Name        ID2            Single
  ----------------------------------------------------
   1            ABC         1            100
   2            DEF         1            200
  </code></pre>
  
  <p>Table 2</p>
  
  <pre><code> ID1         Name        ID2           Monthly
  ----------------------------------------------------
   3            PQR         2            500
   4            LMN         2            600
  </code></pre>
  
  <p>I want Output</p>
  
  <pre><code> ID1         Name        ID2            Single   Monthly
  --------------------------------------------------------
   1            ABC         1            100        NULL
   2            DEF         1            200        NULL
   3            PQR         2            NULL       500
   4            LMN         2            NULL       600
  </code></pre>
  
  <p>I used all Joins nothing working 
  thanks in advance</p>