Would like for the results to become pivoted and be transposed to look
like this.
There's a little step-by-step for this at
http://www.artfulsoftware.com/queries.php under 'Pivot tables', 'Group
column statistics in rows'.
PB
-----
Ow Mun Heng wrote:
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
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.1/389 - Release Date: 7/14/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
