Archives of the TeradataForum

Message Posted: Fri, 31 Mar 2006 @ 19:12:11 GMT

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

<-- Anonymously Posted: Friday, March 31, 2006 13:15 -->

Try to change your SQL to the following:

     update a
     FROM PRODDSS_DEV.POITOUSE a,
     PRODDSS_DEV.POITOUSE b
     set ORD_QTY = b.DLV_QTY
     WHERE a.PO_NBR = b.PO_NBR
     and a.ITM_NBR = b.ITM_NBR
     and a.ENTR_DT = b.ENTR_DT

You can find the same example in the SQL reference manual for update in DML portion.

Hope this helps

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