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 gkittelson 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
Fantastic! Perhaps you can help with one more? These two have been playing havoc with my brain. Each peice of equipment can be tested many times and a certificate is given everytime it passes of fails. If the equipment passes then its date for recall is 1 year from the pass date. Here's my SQL... -
Select query with join on a single table
That didn't work, thanks anyway! Here's the table create. You can forget all the columns other than the primary key, id_customer and category. The category can only be 1,2 or 3. At the moment the table has 11 rows and only id_customer 1 has submitted equipment to category 2. create table... -
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...
