Rowset string concatenation

[varmamkm]

I have a table with the following information

CREATE TABLE TEST2 (ID1 INT, NAM1 VARCHAR (20), PLANT VARCHAR (20))
INSERT INTO TEST2 VALUES(1,'AA1','P1')
INSERT INTO TEST2 VALUES(1,'AA1','P2')
INSERT INTO TEST2 VALUES(1,'AA1','P3')
INSERT INTO TEST2 VALUES(1,'AA1','P4')
INSERT INTO TEST2 VALUES(1,'AA1','P5')
INSERT INTO TEST2 VALUES(2,'AA2','P6')
INSERT INTO TEST2 VALUES(2,'AA2','P2')

can anybody help me out to get the result set like this:

ID1     NAME1       PLANTS
---     ------      -------------------
1          AA1      P1, P2, P3, P4, P5
2          AA2      P1, P2
 

thanks in advance

[sakumar9]

This is not possible with SQL. You can have this kind of output generated with your application.

Regards
--- Sanjay