title: Retrieving all desired records from SELECT...IN subquery table when some values are NULL
body: <p>I have a table <code>Table1</code> that contains a field <code>Id</code> and some other fields:</p>
  
  <pre><code>Id    SomeField
  ------------------
  1     SomeValue
  3     AnotherValue
  </code></pre>
  
  <p>I have another table <code>Table2</code> that contains a field <code>Id</code> corresponding to <code>Table1.Id</code>, and another field <code>Name</code>. Some of the <code>Name</code> values are <code>NULL</code>:</p>
  
  <pre><code>Id     Name
  -----------
  1      John
  2      NULL
  </code></pre>
  
  <p>I am selecting data like this:</p>
  
  <pre><code>Select Id from Table1 where Name in (Select Name from Table2)
  </code></pre>
  
  <p>In this case, I am getting only John's <code>Id</code> (<code>1</code>) from the above query because of the <code>NULL</code> in the second row of <code>Table2</code>.</p>
  
  <p>How can I get both <code>Id</code> values?</p>