missing set keyword

mani vannan

New Member

Join Date: Nov 2011

Posts: 3
#1

missing set keyword

Nov 23 '11, 03:24 PM

update em123,de123 set em123.sal=sal+1 7000,de123.dnam e='manager' where em123.eno=de123 .eno
Tags: None
rski

Recognized Expert Contributor

Join Date: Dec 2006

Posts: 700
#2

Nov 23 '11, 04:32 PM

You can not update two tables with one UPDATE query.
You have to split query into two queries.

Code:

update em123 set em123.sal=sal+17000 where em123.eno in (select eno from de123)

Code:

update de123 set de123.dname='manager' where de123.eno in (select eno from eml23);

If tables are rather big you can use EXISTS instead of IN
Comment

Comment