looking for a query

[iboff]

Hi,

here is my problem looking for this query that could help me.

I have a table paquet_product that has the following fields:
paquet - product
10 - 1
10 - 3
10 - 5
20 - 1
20 - 3
30 - 1

I would like to make a query which return me the paquet that have only the product 1 and 3.

whit this query:
select paquet from paquet_product where product IN(1,3) group by paquete having count(*) = 2;

i get return the 10 and the 20 but i just want the 20 because the 10 has also the 5.

anyone?

thanks

[iburyak]

Try this:

declare @aaa table ( paquet int, product int)
 
insert into @aaa values(10, 1)
 
insert into @aaa values(10, 3)
insert into @aaa values(10, 5)
insert into @aaa values(20, 1)
insert into @aaa values(20, 3)
insert into @aaa values(30, 1)
 
select paquet
from @aaa a
Where product in (1,3)
and not exists (select * from @aaa where paquet = a.paquet and product not in (1,3))
Group by paquet
having count(*) = 2

Good Luck.

[mcasaurabhsumit]

Write in this way and check the result:
Select paquet,product from paquet_product where product between 1 and 3 order by paquet

Hi,

here is my problem looking for this query that could help me.

I have a table paquet_product that has the following fields:
paquet - product
10 - 1
10 - 3
10 - 5
20 - 1
20 - 3
30 - 1

I would like to make a query which return me the paquet that have only the product 1 and 3.

whit this query:
select paquet from paquet_product where product IN(1,3) group by paquete having count(*) = 2;

i get return the 10 and the 20 but i just want the 20 because the 10 has also the 5.

anyone?

thanks