Archives of the TeradataForum
Message Posted: Thu, 02 Dec 2004 @ 20:13:48 GMT
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;
Anthony S. Howe
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|