Check if table contains tuple

  • Thread starter Jeroen Verdrengh
  • Start date
J

Jeroen Verdrengh

Hi,

How can I check whether a table contains a certain value in one of his
columns?

greets,

Jeroen
 
J

Jeroen Verdrengh

To be more clear: I wan't to use this expression to exclude records from a
query when their ID is in a table.
 
M

Michel Walsh

Hi,

Check each individual field.


SELECT *
FROM somewhere
WHERE f1<>id AND f2<>id AND f3<>id AND ... ad nauseam



Hoping it may help,
Vanderghast, Access MVP
 
J

Jeroen Verdrengh

ok, but I would like tot do sth. like this:

SELECT *
FROM somewhere
WHERE f1 IS NOT IN table1

any idea?
 
Top