This will show how the different databases handle updating one table and using data from another table.

Database	Code
Oracle 2 Table Update	UPDATE Target_Table TT SET        TT.Target_Column = (SELECT ST.Source_Column                              FROM Source_Table ST                             WHERE TT.Join_Column = ST.Join_Column);
SQL Server