Archives of the TeradataForum

Message Posted: Thu, 02 Dec 2004 @ 20:45:11 GMT

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

That "bug" has bit me quite a few times as well. I understand that ANSI SQL 99 standard does not allow the exact syntax you have. Try the following, which Teradata considers an extension, to accomplish what you're after:

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

--Jason

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