Archives of the TeradataForum
Message Posted: Tue, 12 Dec 2006 @ 17:29:12 GMT
Have a table of transactions which does not have a unique key. This table is a compilations of multible transactions customers have made an has multiple rows with same account numbers, etc.
I believe that for me to update this table with additional data I will have to have a column with a unique key(ID).
Can anyone help me with the update script.
update a from table a, table b set column = b.column where a.accountnumber = b.accountnumber;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|