title: How do I get all the rows in one table that are not in another in MS Access?
body: <p>I have tried a bunch of different things but always get syntax errors.</p>
  
  <p>I have two tables - tableA and tableB. They both have a con_number field as a unique ID.
  I want to select all of the rows in tableB that do not exist in tableA.</p>
  
  <p>Can anyone please give me this query as it would be in MS Access?</p>
  
  <p>I know that using NOT IN is quite inefficient in this case so if there is a better way then that would be great.</p>
  
  <p>Thanks.</p>