I have a table that has the following layout:
req line comment
12345 1 This field has
12345 2 some text in
12345 3 it that should
12345 4 all be together.
Each req will have 1 or more lines with pieces of the whole comment. Is there a way to write a select statement that will return the multiple records into 1 record like:
req comment
12345 This field has some text in it that should all be together.
I hope this makes sense. Thanks for the help...
mwa
<><
req line comment
12345 1 This field has
12345 2 some text in
12345 3 it that should
12345 4 all be together.
Each req will have 1 or more lines with pieces of the whole comment. Is there a way to write a select statement that will return the multiple records into 1 record like:
req comment
12345 This field has some text in it that should all be together.
I hope this makes sense. Thanks for the help...
mwa
<><