Raymond
Teradata - Update with Joins to Another Table
insights Stats
warning Please login first to view stats information.
toc Table of contents
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 4 years ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.