-- Single column example
 
UPDATE TABLE(<SELECT STATEMENT>) <alias>
SET <column_name> = (
  SELECT <column_name>
  FROM <table_name> <alias>
  WHERE <alias.table_name> = <alias.table_name>);
 
  UPDATE CORPDATA.PROJECT X
    SET PRIORITY = 1
    WHERE '1983-09-01' >
       (SELECT MAX(EMENDATE)
           FROM CORPDATA.EMPPROJACT
           WHERE PROJNO = X.PROJNO)
 
/*
As SQL examines each row in the CORPDATA.EMPPROJACT table, it 
determines the maximum activity end date (EMENDATE) for all 
activities of the project (from the CORPDATA.PROJECT table). 
If the end date of each activity associated with the project is 
prior to September 1983, the current row in the CORPDATA.PROJECT 
table qualifies and is updated.
 
Update the master order table with any changes to the quantity 
ordered. If the quantity in the orders table is not set (the NULL 
value), keep the value that is in the master order table.
*/
 
UPDATE MASTER_ORDERS X
   SET QTY=(SELECT COALESCE (Y.QTY, X.QTY)
              FROM ORDERS Y
              WHERE X.ORDER_NUM = Y.ORDER_NUM)
   WHERE X.ORDER_NUM IN (SELECT ORDER_NUM 
              FROM ORDERS)
 
 
-- Multiple column example
 
UPDATE <table_name> <alias>
SET (<column_name_list>) = (
  SELECT <column_name_list>
  FROM <table_name> <alias>
  WHERE <alias.table_name> <condition> <alias.table_name>);