Posted by markjerz@googlemail.com on 01/23/07 16:21

Say I have a table of data containing something like

Region | County | Year | Month | Value

for some sort of value (int). I want to re-arrange this data so that it
comes out like this:

Region | County | Year | J | F | M | A | M | J | J | A | S | O | N | D

where the letters are obviously the months in order. How would I go
about this/what's the best way. I attempted to use 12 INNER JOINS on
the table itself, sadly that failed miserably. Also, this doesn't seem
very efficient?

Before you ask I got rid of my original code (gave up!)

[Back to original message]