Many thanks for your response!
George
Type: Posts; User: jlloret; Keyword(s):
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
...