[AccessD] In this Query but NOT that Query

Glad I could help. NOT IN() typically runs more slowly than a join would, but with such a small number of rows you wouldn't notice.
 
Arthur 



----- Original Message ----
From: Dan Waters <dwaters at usinternet.com>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Sunday, March 25, 2007 4:30:31 PM
Subject: Re: [AccessD] In this Query but NOT that Query


Hi Art,

There is joy in the world! (at least in my world!) :)

I've never used subqueries before and I've never seen the NOT IN syntax.
Seems really useful.

No, there were no duplicates in either list.  With this example, the most I
could expect back would be 8 if all the 13 were different that those first
8.  

Thanks!
Dan