Re: [SQL] Concatenate strings using GROUP BY

2006-02-09 Thread A. Kretschmer
am 09.02.2006, um 10:35:03 +0100 mailte Philippe Lang folgendes: > idfkstr > --- > 1 1 a > 2 1 b > 3 2 c > > Is there a pure SQL way of contactenating str values into a single string, > and get instead: > > idfkstr > --- > 1 1

[SQL] Concatenate strings using GROUP BY

2006-02-09 Thread Philippe Lang
Hi, Let's say we have a query like: SELECT id, fk, str FROM foo ... which returns: idfkstr --- 1 1 a 2 1 b 3 2 c Is there a pure SQL way of contactenating str values into a single string, and get instead: idfkstr --- 1 1