Join without duplicates
Date: November 28, 2011 11:22AM
I have the following three tables and wish to select the competitorName and competitorDescription just once along with all the scores for that competitor.
I have tried several different JOIN queries but the competitorName and competitorDescription are always duplicated based on the number of rows returned from the score table.
Any help would be greatly appreciated! Thanks.
id competitorId eventId eventScore
1 5 7 12
2 5 8 21
3 6 7 11
4 6 8 23
id competitorName competitorDescription
5 A company description of company
6 Another company description of another company
id eventName eventDescription
7 Pub Quiz Description of Pub Quiz
8 Snooker Description of Snooker
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.