Is there a way in SQL to concatenate strings from different rows
into a list?
My boss wants a re****t of consolidated data with one column being
the transaction numbers involved in the consolidated data. I could
easily concatenate with xBASE commands, but is there a way with just
SQL?
Example: I have
client dollars trnnbr
------ ------- ------
ABC 100.00 101
DEF 200.00 117
DEF 300.00 123
DEF 400.00 128
GHI 500.00 108
GHI 600.00 111
and want
client totdlrs trnnlist
------ ------- ------
ABC 100.00 101
DEF 900.00 117, 123, 128
GHI 1100.00 108, 111
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
