Archives of the TeradataForum

Message Posted: Wed, 07 Feb 2007 @ 16:34:13 GMT

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

You can try something like:

     UPDATE T1
     FROM    T2
     SET C1 = T2.C1
     WHERE T1.C2 = T2.C2
     ;

Similar syntax for delete.

Sandipan Mishra
3M Center

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