Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to SELECT same records
Sorry, just one more question: how do I add that I want prodid only from shopid 1 and 2? -
-
How to SELECT same records
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! -
Query help needed!
Hi and thanx! However I'm not sure it's a right way to go. For the first I need a select on Products to have a list of products which can be done let's say by workshopid = 1 and 5. And those workshops can use different equipment to produce those products as listed in pairs in table... -
Query help needed!
Hi, really hope someone can help me on this one! We have 6 tables: Products prodid Prodequipment prodid equipclassmain equipclassor Equipclasses classid Equipfunctions equipid classid Equipment equipid Workshopequipment workshopid equipid Products – a list of some products Equipment –...
