title: How to merge two tables in SQL SERVER?
body: <p>I have the following two tables T1 and T2.</p>
  
  <p>Table T1</p>
  
  <pre><code>Id   Value1
  
  1    2
  2    1
  3    2
  </code></pre>
  
  <p>Table T2</p>
  
  <pre><code>Id   Value2
  
  1    3
  2    1
  4    1
  </code></pre>
  
  <p>I need a SQL SERVER query to return the following</p>
  
  <pre><code>Id   Value1   Value2
  1    2        3
  2    1        1
  3    2        0
  4    0        1
  </code></pre>
  
  <p>Thanks in advance!!</p>