what's the best way to do this?

[token_remedie]

so I want an update query, my first few attempts haven't worked they just append not update the table. Anyway what I want it to do is:
check table 1 against table 2 is the record is found then check location in table 2 against table 3 if they are different then update the location from table 1 to table 2, copying the record from table 2 to 3 first.

Basically I want the most up to date record in table 2 but i want history of it kept in table 3. Table 1 is a new data temp import table.

thanks in advance

 

[Guus2005]

Looks like you have much redundancy in your database.
You might want to properly normalise first.