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!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: astralex
  • Content: Threads
  • Order by date
  1. astralex

    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!
  2. astralex

    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 –...

Part and Inventory Search

Back
Top