title: Join two tables in sql-server 2008
body: <p>I have two tables:</p>
  
  <p>Table A : </p>
  
  <pre><code>Id (int), TypeA (varchar(25))
    1        a
    2        Null
    3        b
    4        c
    5        d
    6        v
  </code></pre>
  
  <p>Table B : </p>
  
  <pre><code>Id (int), TypeB (varchar(25))
    2        A
    3        C
    4        null
    5        E
    7        S
  </code></pre>
  
  <p>The result should be:</p>
  
  <pre><code>Id (int), TypeA (varchar(25)), TypeB (varchar(25))
    1         a                   Null
    2         Null                A   
    3         b                   C
    4         c                   Null
    5         d                   E
    6         v                   Null
    7         Null                S
  </code></pre>
  
  <p>Any idea? Thanks</p>