CodeSnip: How to Update a Table by Selecting Records from another Table

In Oracle, the primary focus of this article is not difficult, but in teradata, the same job becomes tougher as the syntax itself varies quite a bit from Oracle and is not a part of the official documentation. In this code snippet, Deepakar explains how to deal with the stated problem with the help of relevant syntax. He begins with a detailed description of the problem followed by relevant code and its analysis.

Source Click Here.