Brand new. easy/stupid question about an update type query.

[GoodLife22]

OK I am new around here so please be nice to me. I am trying to learn on the fly here.

I have a table called "CLIENTS" with fields
CLIENT NAME
ADDRESS
CITY
ST


I have another table called "CLIENTS_NEW" with the same fields.
CLIENT NAME
ADDRESS
CITY
ST


Both tables have the exact same 1645 companies listed the CLIENT NAME field. The "CLIENT" table has information for every client listed in the address, city, st, but the CLIENT_NEW has NO information listed. So how do I move those fields to the new table and keep them with the correct customer?

I am thinking an update query, but I do not know how to say update Client.Address to Client_New.Address where Client.Client Name = client_New.Client Name.

So how do I update those fields to the new table and keep them with the correct customer?

 

[SOS]

You have a classic newbie mistake going on here. You should not be storing the same information in two different tables. Data should be stored in ONE location (per the rules of normalization).

So, why do you feel the need to have two tables like this?

 

[GoodLife22]

Good question. I am NOT going to keep these 3 fields in CLIENTS once the info is moved. I need to basically move these due to the table structure being set up incorrectly.