Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   UPDATE Question
 
From:   Tony Howe

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016