Re: Join without duplicates

[Jørgen Løland]

I don't see how you can do that in a single query. I suggest you go for one of these:

a) Multiple queries
   1: select id, competitorname, competitordescription from competitor
   2: for each competitorid: select eventname, eventdescription, score
                             from event join scores on scores.eventid=event.id
                             where competitorid=<fill inn id here>
b) A single query, but filter the result in your application layer

I would most likely go for a). If consistency is a concern, just use a transaction.

Hope this helps,
Jørgen Løland
Software Engineer, MySQL, Oracle
jorgenloland.blogspot.com