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!
Mark McCasland
Midlothian, TX USA