help with update query

[rosscortb]

Hello, never done an update query before, can't work out where I am going wrong.
I want to update the employee table[Team] with the data in Employee2 table[Team] where both ID's match. When I view the query it looks fine but when I run, it's doing it the other way round, updating employee2 with employee data? I did swap it but never worked.Any ideas thanks Ross

[orange]

Review this material on Update query.
Compare this to the SQL of your query.

[rosscortb]

Thanks but the mostly just shows updates where your changing the name of a city not referring another table

[orange]

This is a sample from one of my databases. You can adjust with your table and field names.

UPDATE table4 AS A 
INNER JOIN table5 AS B 
ON a.SalesCode=B.SalesCode 
SET a.SalesValue = B.salesvalue;

Note the UPDATE table4 ----this indicates which of the tables you want to update.

Your initial post showed Employee2 (not the table you wanted to be updated).
Post your query sql if you have questions.