Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 15 Dec 2011 @ 19:15:35 GMT


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


Subj:   UPDATE through a JOIN syntax
 
From:   David Clough

Hi Guys,

Could one of you check my syntax and let me know where I'm going wrong, please ....

A somewhat cut-down version of the code I'd like to run, but good enough for illustration :

     UPDATE DEVCOADMIN_T.CORCOT01 TGT
     SET CON_ID = CORCOT01.CON_ID , EDW_LOAD_TD = CORCOT01.EDW_LOAD_TD ,
     CON_DELETE_IN = CORCOT01.CON_DELETE_IN , CON_ADD_TD = CORCOT01.CON_ADD_TD
     WHERE TGT.CON_ID = CORCOT01.CON_ID

gives me 3806: Table name 'CORCOT01' is ambiguous.

I'm connected to DEVG123AHE database, so basically I'm trying to Update the CORCOT01 Table in DEVCOADMIN_T from the same Table name in DEVG123AHE.

Would I be right in saying that I can't do this ? ?It looks as though the Table names have got to be different, and yet that seems a little restricted.

Can you put me out of my misery ?


Regards

David Clough
Senior Database Designer
Database Design Group



     
  <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