Archives of the TeradataForum
Message Posted: Tue, 20 Jun 2006 @ 19:16:03 GMT
I am trying to update a column in table1 with another column in table2. When executing the query, I get the "Return Target Row updated by multiple source rows" message. Here is the query I am executing:
UPDATE TAB1 FROM (SELECT CNAME FROM TAB2 b WHERE b.COL1 = TAB1.COL1) VAL SET COL2=VAL.CNAME;
Also is there a way to update a column where we have to you a funtion like 'min/max' on the source column. I get an error saying "No aggregate funtions allowed."
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|