Archives of the TeradataForum

Message Posted: Fri, 31 Mar 2006 @ 11:32:35 GMT

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

You can.

But if I were you I would code your update like this:

     update PRODDSS_DEV.POITOUSE
     set ORD_QTY = DLV_QTY
     ;

(I don't understand what is the reason of using the from clause when in the where clause you specify the same join fields and nothing else....)

or at least:

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

(you need the alias at the 'update side' of the where conditions).

Hope this helps,

Bye

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