table data for IN keyword

lisa.roney@busi · #1 (**permalink**) 02-06-03, 18:25

I want a WHERE clause to be something like:
WHERE ID NOT IN ('v1','v2','v3',...) but I want the v1,v2,v3,... to be the result of a select from another table. Is this possible?

Bernd Dulfer · #2 (**permalink**) 02-07-03, 03:36

Quote:

I want a WHERE clause to be something like:
WHERE ID NOT IN ('v1','v2','v3',...) but I want the v1,v2,v3,... to be the result of a select from another table. Is this possible?

Depends on your rdbms.

With most you can do this:

select a,b,c
from mytable
where id not in (select id from anothertable)