Is there an efficient alternative to "Not In" in MS Access Query? -

It looks like a no query in MS Access is expensive, because these questions are usually Let's go very slowly. Is there any alternative way to do such a query to avoid this overhead?

You can use !! !

using either Join Left or Join Right What You Should Do! (Include the WHERE clause IS NULL

(so that either middle left or middle right diagram).

Something like this:

  SELECT * except for one table left = b.Value b.AnotherOrSameValue IS NULL  

---

Please note

/ P>