title: Comparison between two tables
body: <p>I am trying to pull in an ID number and name from one table that checks to see if the same ID number does not exist in another table. I am getting the error:</p>
  
  <blockquote>
    <p>Subquery returned more than 1 value.</p>
  </blockquote>
  
  <p>Below is my query.</p>
  
  <pre><code>Select Table1.ID,
         Table1.Name
    From Table1
   Where Table1.ID not in ((select (Table2.ID)
                              from Table2 ) 
                           COLLATE SQL_Latin1_General_CP1_CS_AS)
  </code></pre>