-
row values to column?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|