choosing data using "in" in join queries

  • Thread starter Thread starter toby
  • Start date Start date
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
 
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
 
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...
 
Back
Top