Archives of the TeradataForum

Message Posted: Thu, 31 Mar 2005 @ 12:32:48 GMT

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

Hi,

You can use the following

     Update
         A
        From
            Table1 DT,
            Table2  A
             SET Col1 = DT.col1
        WHERE A.col2= dt.col2

Regards,

Vijay

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