Search:

Many thanks for your response!
George

Hi,
Thank you for your response, but...

I had proposed to change the definition of the view

CREATE VIEW emp_dept AS
2 SELECT a.empno, a.ename, a.sal , b.deptno, b.dname
3 FROM emp a, dept...

Hi,

You say that

F)user can't refer to the columns of a non-key-preserved table in an insert statment.

But, let us suppose that the table dept is dept(deptno,dname)
and the view is
...