[thelist] basic SQL many-many optimization

[Tab Alleman]

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.