choosing data using "in" in join queries

T

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
 
M

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
Click to expand...
("001","...","...") ] for choosing data
 
T

toby

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

Mark said:
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
Click to expand...
("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


.
Click to expand...
Click to expand...
 
Top