Is there a way in SQL to concatenate strings from different rows
into a list?

My boss wants a report 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.

Gene, is the data in FoxPro or a SQL database? I've seen a command
for something like this in MySQL.

Eric

Gene, is the data in FoxPro or a SQL database? I've seen a command
for something like this in MySQL.

Eric

Gene, is the data in FoxPro or a SQL database? I've seen a command
for something like this in MySQL.

Eric

Gene, is the data in FoxPro or a SQL database? I've seen a command
for something like this in MySQL.

Eric

Gene, is the data in FoxPro or a SQL database? I've seen a command
for something like this in MySQL.

Eric

Gene, is the data in FoxPro or a SQL database? I've seen a command
for something like this in MySQL.

Eric

Gene, is the data in FoxPro or a SQL database? I've seen a command
for something like this in MySQL.

Eric

Gene, is the data in FoxPro or a SQL database? I've seen a command
for something like this in MySQL.

Eric

Gene, is the data in FoxPro or a SQL database? I've seen a command
for something like this in MySQL.

Eric