Archives of the TeradataForum
Message Posted: Wed, 04 Feb 2004 @ 22:29:29 GMT
For security reasons, I will not be able to post the actual query. But I can assure you that the query is very similar to the query that you have posted.
I am updating a table.
UPDATE TABLE1 a FROM ( SELECT COALESCE(b.key_field, c.key_field) As drv_key_field, COALESCE(b.new_field, c.new_field) AS drv_new_field FROM TABLE2 c LEFT OUTER JOIN TABLE3 b ON c.key_field = b.key_field) drv SET new_field = drv_new_field WHERE drv.key_field = a.key_field;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|