How to SELECT same records
How to SELECT same records
(OP)
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!
Table ProdsInShops
Shopid|Prodid
______|_______
1 |1
1 |2
1 |3
2 |4
2 |2
Thank you!
RE: How to SELECT same records
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: How to SELECT same records
RE: How to SELECT same records
RE: How to SELECT same records
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?