17.05 - Example: UPDATE Specifying a Correlation Name for the Updated Table in the FROM Clause - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

Because the following UPDATE request specifies the correlation name e for employee in its FROM clause, you must specify e in place of employee immediately following the UPDATE keyword.

     UPDATE e
     FROM employee AS e, department AS d
     SET salary = salary * 1.05
     WHERE e.emp_no = d.emp_no;