HOW TO : concat text fields using a GROUP BY statement ?

Hello,

I have a table with a "name" field and another field for ex : "position"
that is the grouping criteria :
Example of the table content :

Name | Position
===========================
Fred | 1
Edouard | 3
Seb | 1


I would like to make a request that returns this recordset :

Fred + Seb | 1
Edouard | 3

That's to say, a SQL that groups AND concats (with '+' here) the names
having the same position number.

In fact, is it possible to group AND concat on a text field in a SQL request
?

Thanks for any help

Best regards

Fred

Fred schrieb:
> Hello,
>
> I have a table with a "name" field and another field for ex : "position"
> that is the grouping criteria :
> Example of the table content :
>
> Name | Position
> ===========================
> Fred | 1
> Edouard | 3
> Seb | 1
>
>
> I would like to make a request that returns this recordset :
>
> Fred + Seb | 1
> Edouard | 3


SELECT GROUP_CONCAT(Name SEPARATOR ' + ') FROM table GROUP BY Position;

Stefan