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