Hi , Sorry to ask this question,
but I'm in desperate need to acomplish this report, and don't even know
it is possible to be done.
The thing is I have to turn rows from one table into columns
in other table. The first table looks like this
T1
-----------
id cod
-----------
1 bb
1 ff
1 gg
1 kk
2 rr
-----------
An it should be converted to the following format where every cod value
pertaining to T1 should be located into T2 under the specified column
T2
-----------------------------------
id c1 c2 c3 c4
-----------------------------------
1 bb ff gg kk
2 rr
-----------------------------------
I know how to perform this under other languages but don't know how to
do it with mysql's sql.
I think someone else must have had the same requirement before, at least
I hope so.
Thanks in advance,
Mauricio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
