Archives of the TeradataForum

Message Posted: Thu, 02 Dec 2004 @ 20:13:48 GMT

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

The following update statement gives me a 3993 Illegal use of alias name, but it looks good according to the manual?? I trying to update a column in table A from data in table B based on a certain condition (join actually) .

Can I do this??

     UPDATE CCLC07C.ITS_CLAIM_WORK_TABLE       A
          FROM   CCLC07C.ITS_CLAIM             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;

Thanks,

Anthony S. Howe
Teradata Database Administrator
Highmark, Inc.

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