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