Teradata - Update with Joins to Another Table

visibility 2,419 access_time 2 years ago languageEnglish timeline Stats
timeline Stats
Page index 4.33
more_horiz

In SQL Server, JOIN can be used to update target table with values from a joined table. In Teradata, this syntax is not as simple or intuitive as SQL Server. 

Update with a JOIN

The following example updates table test_table1 with data from test_table2.

Database TestDb;
UPDATE test_table1
FROM test_table2 AS SRC
SET amount = amount * SRC.multiplier
WHERE test_table1.category = SRC.category
AND test_table1.amount > 100
AND SRC.is_deleted = 0;

Update with a corelated subquery

This examples shows how to update a table with a corelated subquery.

Database TestDb;
UPDATE test_table1 AS TGT
SET amount = (SELECT amount FROM test_table2 AS SRC WHERE TGT.category = SRC.category)
WHERE TGT.amount > 100;
info Last modified by Raymond 2 years ago copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

More from Kontext
Teradata FastLoad - Load CSV File
visibility 3,857
thumb_up 0
access_time 2 years ago
Check User Access on Teradata
visibility 337
thumb_up 0
access_time 2 years ago
Spark SQL - Convert String to Date
visibility 15,208
thumb_up 0
access_time 1 month