Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

0 views
Skip to first unread message

Fred

unread,
Jul 12, 2005, 4:21:22 AM7/12/05
to
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

0 new messages