WHERE Clause - Teradata Database - Teradata Vantage NewSQL Engine

condition

The predicate that specifies the row to be updated:

• If the UPDATE target is a SET table with a UPI, then only one row can be updated per request.
• If the UPDATE target is a SET table with a NUPI or a MULTISET table, then multiple rows can be updated per request.

table_name_2

Name of the table or queue table in which the row set is to be inserted, or the name of the view through which the base table is accessed.

This name must match the name specified for table_name_1.