Posted by AdrianG on 04/03/07 19:28

I am trying to write a single SQL query that would retrieve the data
that I need. For example, I have a table called Athletes that has 2
fields: name and sport containing the name of an athlete and the
sports that he or she participates in. Some sample data:
John,hockey
Michael,football
John,swimming
Eric,swimming
Michael,baseball

I need a SQL query that would return each athlete and the sports they
participate in:

John - hockey,swimming
Michael - football,baseball
Eric - swimming

I've tried all sorts of joins and aggregate functions but with no
success. I want to avoid to run a query listing the athletes and then
doing a query for each of them to get the sports. Can anyone provide
some tips on doing this with just one SQL query?

[Back to original message]