Archives of the TeradataForum
Message Posted: Tue, 12 Dec 2006 @ 17:29:12 GMT
Subj: | | Update Table Error - 7547: Target row updated by multiple source rows. |
|
From: | | hectorsiverio |
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;
Thanks
|