[AccessD] SQL - Alternative to using NOT IN Clause

What? A field that shouldn't exist? 

Susan H. 


> Make it a left or right join, and then put Is Null in a field that
> shouldn't exist in the table missing records.
>