Archives of the TeradataForum
Message Posted: Wed, 25 Jul 2007 @ 18:19:59 GMT
| Subj: || || UPDATE, SET, & Subquery Re-visited |
| From: || || Anantaraman, Kumaran |
A previous post
asked how to code an UPDATE statement if the expression in the SET clause were to use a subquery.
And suggested answers were like :
SELECT COUNT(1) TOTAL_COLUMN
SET TOTAL_COLUMN = b.TOTAL_COLUMN
However, the FROM clause is (from manual) '.. a Teradata extension to the ANSI SQL-2003 standard.'. So, then, how to code the above
UPDATE functionality without using FROM clause?