Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-04 : 10:32:51
|
Oliver writes "Hi,
I have a simple table :
project_name | member_name | ...
---------------------------------
project1 | oliver | ...
project1 | alice | ...
project2 | bob | ...
project3 | alice | ...
project3 | eve | ...
project4 | oliver | ...
and I'd like an SQL query which gives me something like :
project1 | oliver, alice
project2 | bob
project3 | alice, eve
project4 | oliver
I guess I can do that with a GROUP BY, maybe...
Did you have any idea ?
Thanks
Olive." |
|
|
|
|
|
a (too hard for me) GROUP BY problem