InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 06 Sep 2008 12:31:44 GMT20http://www.teradata.com/teradataforum/Topic11412-9-1.aspxThanks a lot Fred Pluebell.I have done the same which you told.Thanks for you help.Tue, 13 May 2008 08:46:57 GMTMonikahttp://www.teradata.com/teradataforum/Topic11412-9-1.aspxThe "UPSERT" form does not allow a FROM clause (joined update). If using TD12.0, consider MERGE. (If you are not on TD12.0, MERGE is restricted to single-row operations - so appears unlikely to handle what you are trying to do.)Or do it in two parts, joined UPDATE followed by INSERT ... SELECT ... WHERE NOT EXISTSMon, 12 May 2008 21:35:33 GMTFred Pluebellhttp://www.teradata.com/teradataforum/Topic11412-9-1.aspxHi all,when I run the below sql it giving error.could anyone correct me, what is wrong with it. update emp from (select b.emp_no emp_no,b.emp_name emp_name, b.emp_code emp_code, b.salary from emp2 a,emp1 b where a.emp_no=b.emp_no) c set salary=salary*2 where emp_no=c.emp_no else insert into emp(emp_no,emp_name, emp_code, salary)values(c.emp_no,c.emp_name,c.emp_code,salary);*** Failure 5565 The UPDATE specified in the UPSERT statement is a complex update. Statement# 1, Info =485 *** Total elapsed time was 1 second.Mon, 12 May 2008 04:17:57 GMTMonika