G
Guest
Is it possible to run an update statement with a subquery? What is the syntax?
Say you have emp and dept tables.
update emp set emp.depdesc = select dept.description from dept where emp.deptno
= dept.deptno
In other words I want to put values in preexisting records based on another
table. If dept has a description, then I want emp to have fname, lname, deptno,
deptdescription.
Is that possible?
[email protected]
Say you have emp and dept tables.
update emp set emp.depdesc = select dept.description from dept where emp.deptno
= dept.deptno
In other words I want to put values in preexisting records based on another
table. If dept has a description, then I want emp to have fname, lname, deptno,
deptdescription.
Is that possible?
[email protected]