Hi all,
I have a database with two tables, called cost and costdesc. For each
record in cost, there can be 1 to 100 records in costdesc, each of these
records having parts of the narrative of the cost.

I want to create a stored procedure that will select records from the cost
table, and then, for each record in the result set, select records from the
costdesc table and concatenate them into one string, thus:

Cost record -- index, person authorizing cost, amount of cost, date of cost

Costdesc record -- index, line 1, narrative 1
index, line 2, narrative 2
index, line 3, narrative 3


Result set

index, person authorizing cost, amount of cost, narrative 1 narrative 2
narrative 3


Go to next cost record.


Any assistance would be appreciated.

Thanks in advance.

Richard Mogy