missing set keyword

mani vannan

New Member

Join Date: Nov 2011

Posts: 3
#1

missing set keyword

Nov 23 '11, 03:32 PM

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

error:

0ra-00971 missing set keyword

please help me......
Tags: None
Rabbit

Recognized Expert MVP

Join Date: Jan 2007

Posts: 12517
#2

Nov 23 '11, 06:19 PM

I don't think you can update two different tables at once. You'll need to separate them into different update statements.
Comment

Comment