For more information on... See... UPDATE statement Teradata Vantage™ - SQL Data Manipulation Language, B035-1146