hi....

i want to display the row value as column in the output record set.

Table fields:

1. category
2. sub_category

Table Values:
-------------

category ------------ sub_category
==============================
A ------------ A1
A ------------ A2
A ------------ A3
B ------------ B1
B ------------ B2
C ------------ C1
C ------------ C2
C ------------ C3


Actually i need the output like this

A -----B -----C
=================
A1 -----B1 -----C1
A2 -----B2 -----C2
A3 -----NULL -----C3


If this possible in mysql? How to display the row value as column? Please help me any one..? It is very urgent.... for my project.....


Thanks
Regards,
S.Ashokkumar
India