Hi,

I have table like below

PARENT NAME
-------- ------
ABSMBS A1
ABSMBS A2
ABSMBS A3
BNDS B1
BNDS B2
BSB C1
BSB C2
DMA D1

and i want the data to be shown as below but using on SQL query and not using cursors. I am using Sybase 15. Is this possible?

PARENT NAME
-------- ------
ABSMBS A1,A2,A3
BNDS B1,B2
BSB C1,C2
DMA D1