Archives of the TeradataForum

Message Posted: Fri, 31 Mar 2006 @ 11:41:39 GMT

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

Try this...

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

Or, assuming you are updating the Ord_Qty on every row with the value of Dlv_Qty, then you do not need to alias anything nor do you need the where clause:

     update PRODDSS_DEV.POITOUSE
     set ORD_QTY = DLV_QTY

Hope this helps,

Clay

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