How to SELECT same records

[astralex]

Hi, how can I select all prodid in the table below which are availabe in both shopid 1 and 2? The answer should be Prodid 2

Table ProdsInShops

Shopid|Prodid
______|_______
1 |1
1 |2
1 |3
2 |4
2 |2

Thank you!

 

[PHV]

SELECT Prodid FROM ProdsInShops GROUP BY Prodid HAVING COUNT(*)>1

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[astralex]

Great! Thank you for your help!

 

[astralex]

Sorry, just one more question: how do I add that I want prodid only from shopid 1 and 2?

 

[PHV]

SELECT Prodid FROM ProdsInShops WHERE Shopid IN (1,2) GROUP BY Prodid HAVING COUNT(*)>1

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886