Maybe it's a anti-query

[lflopes]

I need a query that shows the "not chosen" values.

That is:
I have table with MANY entry. If I choose FEW (query parameter) how can i write a query that show SOME=MANY-FEW

Thanks

 

[123James]

no offence intended, but the description of your problem makes almost no sense to me what so ever!

 

[neileg]

If you have a list of parameters, you would usually use the IN comparator, eg, IN ("red", "blue", "green") to match records to these parameters.

Conversely you can use NOT IN, eg NOT IN ("red", "blue", "green") to find those records that don't match.