Find new value and replace with old one
 

Hello,

situation is like this, I have 2 identical tables, 2 columns, 1. column -
product name, 2. column - price.This is general table.In the second one I
make changes
in prices.How can I compare these 2 tables in a way to have program which
will check all the prices from Table 1 and Table 2 and from Table 2 will put
new
values in Table 1.

thanks

Find new value and replace with old one
 

One more thing,

1. column - product name, it is number (integer),

thanks


"Steve" wrote in message
...
Hello,

situation is like this, I have 2 identical tables, 2 columns, 1. column -
product name, 2. column - price.This is general table.In the second one I
make changes
in prices.How can I compare these 2 tables in a way to have program which
will check all the prices from Table 1 and Table 2 and from Table 2 will
put new
values in Table 1.

thanks