[thelist] sql group one field

[Ken Schaefer]

I think this is called a "crosstab" query - something the RDBMSes
typically do not handle very well internally (because you are
essentially violating your relational design - you are turning
independant records into a single record, and making them attribute
data)

What you usually do is extra all the records into an array or similar
structure in your business layer, and do some kind of loop, and
assemble the data in the way that you want.

Some RDBMSes have stuff built-in to do this. I don't know about mySQL,
but Access does, though that's an exception rather than a rule AFAIK.

Cheers
Ken


On Tue, 31 Aug 2004 22:18:20 +0200, Richard Bennett
<richard.bennett at skynet.be> wrote:
> Hi,
> 
> I am trying to extract a list from a mySQL database :
> 
> I have this table:
> 
> serie:  model:
> 1234            abc
> 1233            abc
> 1222            abc
> 1111            def
> 1112            def
> 
> I would like this result:
> 
> 1234,1233,1222          abc
> 1111,1112                       def
> 
> Any ideas?
> 
> Thanks,
> Richard.