title: IN NOT IN SQL Server 2005
body: <p>How can I see what is not in the table... I know I know...can only see what is there but come on!!!</p>
  
  <p>So!!</p>
  
  <pre><code>select * from ORDER where State IN ('MA','PA','GA','NC')       
  </code></pre>
  
  <p>So I will get MA and PA but I want to see GA and NC....</p>
  
  <p><code>NOT IN</code>  will return NY,NJ,CT ect....  I just want to see what is in the  ( )</p>