Re: SQL UPDATE of one table based on values of another table -- is it possible?

CONSIDER u have 2 tables
1.emp(empno,ename,job,sal,deptno)
2.dept(deptno,dname,loc)
u could use

update emp
set deptno=(select deptno from dept where loc='SDGFS') WHERE job='dfgdg'

try this out
bye
narayan

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!