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