Combine two rows into one rows in Sybase ASE

344 Views Asked by At

I have a resultset as below:

id fname  lname
11 Tom   Jerry
11 Kim   Harry

Output I expected as below:

id fname     lname
11 Tom,Kim   Jerry,Harry

Appreciate your help. thank you.

0

There are 0 best solutions below