SQL WHERE ... IN selects "any", what selects "all"

[markjkubicki]

I have tables with a one-to-many relationship


the following selects records that match "any" of the values (...correct?)

SELECT tblManufacturers.*
 FROM tblManufacturers
 WHERE tblManufacturers.Catagory IN (value1,value2,...);

simple question:

what is the syntax for a select clause that will only select those records where "ALL" of the values are met?

with thanks in advance,
mark

[orange]

More info please.

Can a manufacturer be in several Categories?

Usually you would have a construct such as

Select * from Table
where
City ='SomecityName' AND
BldgProductCategory ='Siding' AND
someOtherField ='SomeValue"

[markjkubicki]

yes, a manufacturer could potentially be in several...
i had a hunch that I'd have to construct an " and... and... and..." clause

Select * from Table
where City = 'SomecityName_1' 
                  AND City = 'SomecityName_2' 
                  AND City = 'SomecityName_3' 
                  AND City = 'SomecityName_4' 
                  AND <etc.>

(guess i was hoping for the discovery of a "learn sometime new every day" function() ... oh well!)
NTL THNX!

[pbaldy]

I assume this has another use, as your example could never return a record. That's probably why there's no function for it.

[orange]

As Paul says that sql won't return any records. When using an AND construct you would typically involve different attributes.

eg select * from table
where
age = 16 AND
eyecolor = 'green' AND
haircolor ='brown'


A person couldn't be age = 16 AND age = 18 AND age = 20