Archives of the TeradataForum

Message Posted: Fri, 31 Mar 2006 @ 14:30:33 GMT

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

Try creating a derived table from source and then use it for your update. Some thing like this:

     Update table-name
     from (Sel fields from same table where ....) as Derived_Table (fields)
     set field =Derived_table.field
     where Derived_table.field =table-name.field...

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