SQL Delete using joins

Question

I am trying to delete rows from both emp and dept tables using the below query. But after the query executed, it is deleting rows from only dept table and not from emp.

delete  (
select * from  emp e,dept d
where e.empno=d.empno
and  e.sal in  ('200','1950','5000')
and d.objid in ('1001','1002','1003')
);

I am using oracle 8i. Please help!! Thanks in Advance