5092309e_SQL_Statements__Description
[Parameter] WHERE SearchCondition [Description] 
The search condition can contain a subquery. All rows for which the search condition is true are updated as specified in the SET clause. Rows that do not satisfy the search condition are not affected. If no rows satisfy the search condition, the table is not changed.
SQL Statements