Archives of the TeradataForum
Message Posted: Tue, 10 May 2005 @ 19:45:59 GMT
I can find reasons why the following should work(through general SQL documentation) and no explanation why is does not.
Nevertheless, a syntax error is returned through SQL Assistant.
The actual table / column names have been stripped out for simplicity. Ultimately, the goal is to update a column in a summary table with the COUNT(1) from a table of details. Does Teradata not support suqueries outside the WHERE/FROM clauses?
Any information would be appreciated. Thanks.
UPDATE SUMMARY_TABLE SET TOTAL_COLUMN = (SELECT COUNT(1) FROM TABLE_OF_MISMATCHES)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|