[thelist] basic SQL many-many optimization

Tab Alleman Tab.Alleman at MetroGuide.com
Wed Jul 16 13:34:40 CDT 2003

SBeam wrote:
>> Or if you wanted your result set to come out like this:
>> Title		Genres
>> T1		g1, g2, g3
>> T2		g1, g2
>> T3		g1, g2, g3, g4, g5
>> Then maybe you could do some kind of recursive thing?
> thats exactly what I want. What kind of recursive thing?

Unfortunately, I've never done something like this.  I'm hoping someone
like Rudy has and can paste some old code for us all, cuz I don't have a
couple of hours to figure it out myself today.  

More information about the thelist mailing list