Re: Help with formatting of 1:n relationship

[Vikram Vaswani]

Hi,

>> I did consider a procedure but the problem is that the client is still using
>> MySQL 4.x, which afaik doesn't support stored procedures. An upgrade is not
>> something they can do at this point, as they're using s shared host so the
>> server isn't really under their control.
> 
> I think what you're really looking for is a "pivot table" or "crosstab
> report" in SQL itself, right?

I have used pivot tables before but I'm far from an expert on them. I 
wasn't able to understand how I could apply a pivot table structure to 
this problem. Can you give me some more details on what you had in mind?

Thanks,

Vikram