The syntax for the Oracle UPDATE statement when updating one table with data from another table is: UPDATE table1 SET column1 = (SELECT expression1 ...
www.techonthenet.com