Archives of the TeradataForum

Message Posted: Thu, 02 Dec 2004 @ 21:15:41 GMT

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

Hi Tony,

Try this :

     UPDATE CCLC07C.ITS_CLAIM_WORK_TABLE
          FROM   CCLC07C.ITS_CLAIM             B
      SET ITSCL_RCD_CRE_DT = B.ITSCL_RCD_CRE_TS
     WHERE   AAA_CODE                    = B.AAA_CODE
            AND   BM2_SEQ_ID                 = B.BM2_SEQ_ID
           AND    ITSCHH_HM_HS_CD = B.ITSCHH_HM_HS_CD;

Thanks

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