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