moving fields from one table to another

[Mony]

hi there,

I am currently working on updating a database that I created four years ago for a commission record

there are the tables

table 1:

product ID
Carrier Code
Type
State Available
Updated


table 2:
Product ID
Product name
Sub-name
Street Comp
GA Comp



after refreshing my creation, I realized that Product name and sub-name from table 2 should be going to table 1.. How can I move those two fields from table 2 to table 1 without mess up the data?

if you can help me solve the problem, that will be a great appreciate

Mony

[pbaldy]

Add the fields to table 1, run an update query using both tables with a join on product ID to copy the values, then delete the fields from table 2.

[Mony]

Add the fields to table 1, run an update query using both tables with a join on product ID to copy the values, then delete the fields from table 2.

Hi there,

would you mind give me some examples because I don't understand " run an update query using both tables with a join on product ID to copy the values"

thanks

Mony