Merge two records into one

[CSMwebmaster]

I have a query:
SELECT Name, Game FROM Sports

This gives me the following results.

Name | Game
Jane Volleyball
Jane Basketball
Sandy track
Sandy Golf

I would like the result to be using SQL:

Name | Game
Jane Volleyball,Basketball
Sandy Track,Golf

Any Ideas?

 

[r937]

i'm afraid there is no good ANSI SQL solution

please ask this question in the appropriate forum for your particular database system

the solutions vary wildly depending on which system it is

in MySQL, for example, you can say

select name
     , group_concat(game) as games
  from daTable
group
    by name

r937.com | rudy.ca