Home » SQL & PL/SQL » SQL & PL/SQL » sql help (update)
sql help [message #306186] Thu, 13 March 2008 03:27 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member

HI

i want to retrive data  two tables with depended on condition.

asume that 
select a.empno,b.loc from emp a ,dept b
where a.deptno=b.deptno

than i want to update coloumn  e.sal ='y'.

................................................
this logic i want to sigle sql query.


thanks
srinivas





Re: sql help [message #306187 is a reply to message #306186] Thu, 13 March 2008 03:30 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
UPDATE, see examples.

(Seems to be the great question today, 3 times I post this link in a couple of hours.)

Regards
Michel
Previous Topic: Update Statement Using Join
Next Topic: How to Check the date for the statistics last generated
Goto Forum:
  


Current Time: Sun Dec 11 04:36:48 CST 2016

Total time taken to generate the page: 0.10324 seconds