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