update emp set sal=sal*2 where deptno in (select deptno from dept);

The reason you get that error is that Oracle has no idea what deptbak.deptno is, since it isn't (and can't be) listed as the table to update.

[Edited by kmesser on 04-28-2001 at 10:01 AM]