[firebird-support] how to combine a field value while their id is same?

2011-10-23 Thread ibmcom2011
now i have a table such as: f1 f2 1aa 2tf 1bb 3cc 2ht i want the result seems as: f1 f2 1aa, bb 2tf, ht 3cc any help is appreciated, thanks.

Re: [firebird-support] how to combine a field value while their id is same?

2011-10-23 Thread Mark Rotteveel
On 23-10-2011 16:05, ibmcom2011 wrote: > > now i have a table such as: > > f1 f2 > 1aa > 2tf > 1bb > 3cc > 2ht > > i want the result seems as: > > f1 f2 > 1aa, bb > 2tf, ht > 3cc > > any help is appreciated, thanks. The f

Re: [firebird-support] how to combine a field value while their id is same?

2011-10-23 Thread Gordon Niessen
On 10/23/2011 10:01 AM, Mark Rotteveel wrote: > > On 23-10-2011 16:05, ibmcom2011 wrote: > > > > now i have a table such as: > > > > f1 f2 > > 1 aa > > 2 tf > > 1 bb > > 3 cc > > 2 ht > > > > i want the result seems as: > > > > f1 f2 > > 1 aa, bb > > 2 tf, ht > > 3 cc > > > > any help is appreciate