about the delete of joined view
539831May 20 2008 — edited May 20 2008if create a view refering to a single table, then the delete operation to the view will delete the corresponding row in the refered table, but when i create a view by joining two tables, the result seems to be confused.
------------------
create view ev select e.ename,d.loc from emp e,dept d where e.deptno=d.deptno;
delete from ev where loc like 'N%';
------------------
then 3 row was deleted from the view with 3 rows deleted in the emp table, but nothing happened in the table dept which supposed to be also delete;
Why, or is these any principles dealing with the deleting this kinds of view. and I tried, the insert of this view is forbidden.