Check if table contains tuple

  • Thread starter Thread starter Jeroen Verdrengh
  • Start date Start date
J

Jeroen Verdrengh

Hi,

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

greets,

Jeroen
 
To be more clear: I wan't to use this expression to exclude records from a
query when their ID is in a table.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.Net Tips : New Tuple class in .Net Framework 4 1
Syntactic Support for Tuples? 2
Checking if data exists another table and, if yes, extracting a value 0
Two table Insert - One 2 Many relationship 1
Query from two tables to compare 2
Tuples with similar attributes 3
table contents to string 7
How to Return the value of field from two lookup? 1

Back
Top