Ok, here is my problem.
I have two tables.
Table One is a "master" table defined like this:
Table Two contains multiple rows of text for each row in "master" and is
defined like this:
In DTS I need to put those two tables together, joining by master_id and
child_id and concatonate all of the text columns for each match into one
column. The destination table would look something like this:
master_id child_id col1
1 1 XXX
1 2 YYY
master_id child_id text_seq text
1 1 1
This is the first part and
1 1 2
this is the second part
1 1 3
and this is the last part.
master_id child_id text
1 1 This is the first part and
this is the second part and this is the last part.
I hope I have given enough information and yet not too much information to