Susan Harkins
ssharkins at gmail.com
Mon Mar 30 17:33:23 CDT 2009
EXISTS? http://www.devx.com/dbzone/Article/9570/1954 Susan H. > Thanks Max - And i was just looking at (NOT IN) and thinking "oooh, that > looks useful" :) noted!. > > > Darryl, > Do not use the NOT IN clause if you can avoid it. It is extremely slow on > large datasets. The quickest way was given to me (I think by Jim) some > time > back but I cannot recall it and don't have time to go searching right at > this moment. > > I have two queries. Query A and Query B both contain a field called > Clients > (Based on the same underlying data). A and B correctly return a different > number of records in the client field. I want to be able to list which > clients are in query B that are missing in Query A. Basically I want the > opposite of joining the two queries based on the clientfield. >