Archives of the TeradataForum

Message Posted: Fri, 31 Mar 2006 @ 12:08:23 GMT

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

Yes, you can do such an update and the good news is that you don't need this tricky FROM syntax. But what do you want to achieve? Do these three columns (PO_NBR, ITM_NBR and ENTR_DT) always define a unique row? If they do then you could go for the following simple statement:

     update PRODDSS_DEV.POITOUSE
     set ORD_QTY = DLV_QTY ;

If they don't then the UPDATE is not likely to work for reasons other than the use of aliases.

Regards,

Victor

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