Archives of the TeradataForum

Message Posted: Fri, 15 Dec 2006 @ 11:07:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Friday, December 15, 2006 05:42 -->

Hi ,

I think you will need to select unique rows from the source table to update the target table.

A sample query may be as follows.

     Update   a
     From table_a a,
     (
     Select Max(column_b)  column_b, accountnumber
     From table_b group by accountnumber) b
     Set column = b.column_b
     Where a.accountnumber = b.accountnumber;

We need to have unique matching rows on the source table to avoid the error you are facing.

I hope this help.

	<Prev	Next>		<<First	<Prev	Next>	Last>>