Update Using nested Select / Corelated Subquery 1

[SQLPilot]

I have a table that I have extracted portions of data into a CSV. Excel users updated the data and I now need to update numerous rows and columns. I have moved the data back into a temp table in SQL. I need to update the requirement and Description columns in the original table with the equivalent row from the temp table. I can link by the primary key column, as the key field was included in the original export.

I am sure that there is a way to use either a nested update / select query or a corelated subquery in an update statement to accomplish this, but am having total brain fry trying to remember the syntax.

Any help will be greatly appreciated.

 

[kandym]

How about something like:

update table set description = (select description from temptable tt where tt.key = table.key) where key in (select key from table)