Query

Thriu · #1 (**permalink**) 08-23-04, 05:50

Hi,
I have a table like Sample_Material
fiels are ID,Material Number and Sample Number. A sample contains number of material numbers like
ID Material_Number Sample_Number
1 10 1000
1 11 1000
1 12 1000
1 10 1001
1 13 1001
1 10 1002
1 12 1002
1 11 1002

I have to select Sample Number which contains number of material numbers when i select by material numbers. say for example if i select material numbers 10,11 means i should get only 1000 and 1002 sample number(It should not select 1001 which contain only 10) which contains these two material numbers.

I am using MySQl database.

Pls help me to make the query.
Thanks in advance,
Thiru

r937 · #2 (**permalink**) 08-23-04, 07:50

Code:

select Sample_Number
  from Sample_Material 
 where Material_Number in (10,11)
group
    by Sample_Number
having count(distinct Material_Number)
     = 2

Internet Services

Web Development

Digital Marketing

Consumer Tech