choosing data using "in" in join queries

[toby]

hi
i ve used the join queries for searching data in different table.
eg. i 've a column named "code", which possible different no.s, say 001,
213, 235, .............

i know if i can use [where code in ("001","...","...") ] for choosing data
with 001 or ... or .... in the column "code".
but how can i make an alternate function which choosing data from the table
except those with 001, or ... or.... in the column "code"??
thanks in advance.

from Toby

 

[Mark]

Toby

Try using WHERE Code NOT IN ("001","...","...").

FYI, if you are using this on very large tables, the
query may run a little slow as Access isn't optimized for
NOT IN statements.

Mark

-----Original Message-----
hi
i ve used the join queries for searching data in different table.
eg. i 've a column named "code", which possible different no.s, say 001,
213, 235, .............

i know if i can use [where code in

("001","...","...") ] for choosing data

 

[toby]

it works
thanks. but really a bit slower than using "in" function !!

Toby

Try using WHERE Code NOT IN ("001","...","...").

FYI, if you are using this on very large tables, the
query may run a little slow as Access isn't optimized for
NOT IN statements.

Mark

-----Original Message-----
hi
i ve used the join queries for searching data in different table.
eg. i 've a column named "code", which possible different no.s, say 001,
213, 235, .............

i know if i can use [where code in

("001","...","...") ] for choosing data

with 001 or ... or .... in the column "code".
but how can i make an alternate function which choosing data from the table
except those with 001, or ... or.... in the column "code"??
thanks in advance.

from Toby


.