how to combine multiple records for the same item into one line

[graziaR]

Hi,
I have a table, call it TEST, in which a records of a person's test dates and scores are kept.
For instance, a person might have taken twice a toefl test and one a math test. The table would look like this:
personId test score date
1111 toefl 234 02/04/2005
1111 toefl 444 03/07/2006
1111 math 333 05/06/2006

I woudl like to loop through the records of that person and to put them all on one line. That is, I woudl like the result to show something like this:
personId test_1 score_1 date_1 test_2 score_2 date_2 test_3 score_3 date_3 ....

Is this at all possible with MySQL ? I am using Oracle 9i.

Many thanks for any suggestion !

 

[TonyGroves]

You could use:
[tt]
SELECT
personid,
GROUP_CONCAT(CONCAT(test,' ',score,' ',testdate))
results
FROM tblname
GROUP BY personid
[/tt]

 

[r937]

what does "Is this at all possible with MySQL ? I am using Oracle 9i" mean?

there is no GROUP_CONCAT function in oracle

which database are you using, mysql or oracle?

r937.com | rudy.ca

 

[graziaR]

Sorry for the confusion.
Oracle 9i

 

[r937]

okay, please post your questions in forum759

r937.com | rudy.ca

 

[graziaR]

Thank you, I posted my question on the forum you suggest.