Mark,
Don't know about Oracle, but in SQL Server I would use the following syntax:
UPDATE Table1
SET Table1.Staff_ID = Table2.KeyID
FROM Table1 INNER JOIN Table2 ON Table1.Location = Table2.Location
or
UPDATE Table1
SET Table1.Staff_ID = Table2.KeyID
FROM Table1, Table2
WHERE Table1.Location = Table2.Location
HTH
>IN ORACLE -- Using SPT, 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!
Daniel