title: SQL: How do I check for records in one table that aren't in another?
body: <p>I want to find records that are in one table but not in another.  Except the records aren't formed the same. So I'm wanting to determine the columns I want to use to compare against. I thought I had it worked out with the following code, but it doesn't seem to be working (Returns zero records)...</p>
  
  <pre><code>SELECT A.Name, A.Position, A.[Year]
    FROM TABLE A
   WHERE NOT EXISTS (
  
   SELECT B.Name, B.Position, B.[Year]
     FROM TABLE B
  )
  </code></pre>
  
  <p>Or should I be doing this with some kind of join? Thanks...</p>