Archives of the TeradataForum

Message Posted: Fri, 31 Mar 2006 @ 11:47:03 GMT

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

Hi Peter,

Yes we can do an update on the same table.

But for update stmt we cann't qualify the columns in a set clause. Also for this stmt there is no need for aliasing the table. Just run the below update it will work:

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

Thanks,

Praveen

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