I need to update a column in one table with data from another table, but I can not get the syntax right. Basically what I want to do is:

UPDATE Table1
SET Table1.Staff_ID = Table2.KeyID
WHERE Table1.Location = Table2.Location

The Location column in each table is unique. TIA!