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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multiple joins between tables.
Hello! I posted this question as a follow up to a previously answered question, and decided that this is completely different and should be treated as a new post (doh!). Each peice of equipment can be tested many times and a certificate is given everytime it passes of fails. If the equipment... -
Select query with join on a single table
Hello! I need to query a table that contains id_equipment, id_customer and id_category columns. Multiplicity: one customer submits many pieces of equipment. One piece of equipment belongs to one category. I need to write a query to return all id_customer's that have only submitted equipment to...
