Hello, I've found some documentation on transposing tables, generating crosstabs (e.g. http://dev.mysql.com/tech-resources/articles/wizard/print_version.html). To be honest I've to admit that I tried to figure out how it works, but I'm not able to adopt it to my problem.
My starting table looks like: mnr kw Produktion Stillstand Wartung 63210 25 6143 183 0 63210 26 6410 116 0 63210 27 6817 160 16 63210 28 7481 149 0 63210 29 4345 136 213 63210 30 5168 162 0 What I want is: mnr 63210 63210 63210 63210 63210 63210 kw 25 26 27 28 29 30 Produktion 6143 6410 6817 7481 4345 5168 Stillstand 183 116 160 149 136 162 Wartung 0 0 16 0 213 0 How can I achieve this? regards Volker -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
