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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
