Hi, I have a query that comes out like this.
Program Status Param1 Param2 Param3 Param4 Param5 A 1 1.1 2.2 3.3 4.4 5.5 B 2 2.2 3.3 4.4 5.5 6.6 C 3 3.3 4.4 5.5 6.6 7.7 Would like for the results to become pivoted and be transposed to look like this. Program A B C Status 1 2 3 Param1 1.1 2.2 3.3 Param2 2.2 3.3 4.4 param3 3,3 4.4 5.5 Param4 4.4 5.5 6.6 Param5 5.5 6.6 7.7 Thanks -- Ow Mun Heng <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
