Update a tables all fields with Inner Join

[kashif.special2005]

Hi,

I am New to Access so apologize if this is straightforward.

I have 2 tables in DB. The intent is to update every field (67 in total) with tables "GDC_Structure" to "GDC_Structure_Copy" where the columns "Unique_ID" match. The fields in the "GDC_Structure" table and the Update Tables match identically.

I don't know how can I update all fields (except Unique_ID) at once.

Please help me to solve this problem.

Thanks
Kashif

 

[Minty]

Firstly, it is not normally good practice to make a complete copy of existing data, this may mean a poor design choice, so it might help to explain why you want the duplicate data.

To answer your question, you can use an update query to update all fields in the target table at once - build a query that joins the two tables on the matching ID field , then change it to an update query and simply add each field from the copy table, with the update to: originaltable.field