Re: How to update 2 joinable tables in one satement ?

On Tue, 16 Apr 2002 19:59:53 -0400, "R Chin" <rchin_at_panix.com> wrote:

>How can I update
>the joined records of
>EMP.colx and DEPT.coly
>in one statement ? Is this possible ?
>
>Thanks
>
>Robert
>-- 8.1.7/AIX --
>

Use an inline view.
update (select emp.colx, dept.coly from emp, dept where emp.deptno =
dept.deptno) set  ....

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Apr 16 2002 - 23:47:52 CDT