Is it possible to update all records of a table using an update something like:

update table1 set field1 = select field1 from table2 where field2 = table1.field2

The above does not work. Am I hoping for too much?