Here’s another resource in our ongoing coverage of query techniques:
Learn how to create queries to find all the records in one table that don’t have corresponding records in another table. If you’re not familiar with the difference between Inner Join, Outer Join, Left Join and Right Join, check out our paper on Microsoft Access Outer Join Query: Finding All Records in One Table but Not Another and Creating “Not In” Queries on these important query feature. It’ll save you tons of time trying to code this yourself and will surely give you new ideas on how to better retrieve and analyze your data. The techniques apply to both Microsoft Access and SQL Server queries.