Archives of the TeradataForum
Message Posted: Thu, 15 Dec 2011 @ 19:15:35 GMT
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 ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|