Table A - Col a1, Cola2
Table B - Col b1 and Col b2
Now using DTS I transfer a1 to b1 ONLY.
Now later I decide to transfer a2 to b2. How do I do that such that b2 is appended to the record b1. Using INSERT I end up not appending b2 to b1. b2 adds more rows to table B. Can this appending be done without using a WHERE predicate.