Adding data to columns

Hi,

Say I have two tables.

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.

ThanksHi,

I see two possibilities.

1. You can use an update-statement (unfortunately) with WHERE.
or
2. You TRUNCATE your table B and design a DTS package which transfers both columns from table A to table B.

Greetings,
Carsten