 |
 |
Archives of the TeradataForum
Message Posted: Wed, 25 Jul 2007 @ 20:16:41 GMT
| Subj: | | Re: UPDATE, SET, & Subquery Re-visited |
| |
| From: | | Dieter Noeth |
Kumaran Anantaraman wrote:
| | 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? | |
Using Standard SQL?
UPDATE SUMMARY_TABLE
SET TOTAL_COLUMN =
(SELECT COUNT(1) TOTAL_COLUMN
FROM TABLE_OF_MISMATCHES)
But this is not supported in Teradata SQL.
You finally got the choice between non-supported Standard SQL and supported non-Standard SQL ;-)
Dieter
| |
