I have two tables both of which contain aprox 2000 rows and 3 columns. The headings in each column are repectively: tariff level, product code, product description.

The problem is best illustrated with an example:

Table 1
Tariff Level Product Code Product description
10% 0236 Animal fats
15% 4579 Industrial Chemicals
12% 2093 Tapes

Table 2
Tariff Level Product Code Product Description
13% 1463 Meat
13% 4579 Compact disc's
16% 2967 TV's

I want to move Meat and TV's from table 2 to table 1. The compact disc entry in table 2 has the same product code as chemicals in table 1, this is an error, i don't want this row to go into table 1.

Anybody know a quick way of doing this, i have alot of data.

Chris