Table Modification   «Prev 

Updating with Query Syntax

UPDATE <table_name> <table_alias>
SET<attribute_name> =(SELECT REF(alias) 
  from <table_name> <table_alias>
  WHERE <cluase>)
WHERE <clause>;

Syntax to update with Query

Location 1 The UPDATE statement specifying the table
Locations 2-4 The sub query to retrieve the reference information
Location 5 The WHERE clause