Update rows in a table.Syntax
UPDATE <table_name> [AS alias] SET <column1_name> = <value1> [, <column2_name> = <value2> ... ] [ WHERE where_conditions ]
The path path to the source that you want to update a table in.
Sets the value of one or more columns. The value can be any expression or sub-query that returns a single value.
(Optional) The filter for specifying which rows of the table to update.
Join conditions are not supported in WHERE clauses. If you need to use a join condition, use a MERGE statement.
Example unsupported UPDATE command
update t2 set id = id + t1.id from t1 where t1.name = t2.name;
Equivalent MERGE command
merge into t2 using t1 on (t1.name = t2.name) when matched then update set id = t2.id + t1.id;