Archives of the TeradataForum

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

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

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>>