Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 02 Aug 2002 @ 12:55:21 GMT


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


Subj:   Update through a Join
 
From:   David Clough

Can anyone tell me where I'm going wrong with the syntax on the following update through a Join statement?

database DEVRMS_V;
--
UPDATE RMSCON_V01
SET CON_SRKY_ID = DEVCONS_V.CON_SRKY_ID
where RMSCON_V01.CON_ID = DEVCONS_V.CON_V01.CON_ID
and RMSCON_V01.COM_ID = DEVCONS_V.CON_V01.COM_ID
and RMSCON_V01.BUL_ID_ORIG = DEVCONS_V.CON_V01.BUL_ID_ORIG
and RMSCON_V01.CON_CREATE_DT = DEVCONS_V.CON_V01.CON_CREATE_DT
and RMSCON_V01.CON_CREATE_TM = DEVCONS_V.CON_V01.CON_CREATE_TM;

I get error 3706 : expected something between the word ' ' and the word DEVCONS_V.

According to the syntax helper in Queryman, we have :

"UPDATE employee
SET PhoneNo = PhoneList.Number
WHERE employee.Name = PhoneList.Name ;"

Although I've tried many combinations, this frustrating syntax has me beaten into submission.

Thanks, David.Clough



     
  <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