Update view

From: Maggie <maggiezhou_at_hotmail.com>
Date: Thu, 30 Mar 2000 22:51:12 -0800
Message-ID: <8c1ht4$uo$1@web1.cup.hp.com>

When I try to update a view, I get an error:

CREATE TABLE t1
(

  c1                         NUMBER,
  c2                         NUMBER

 )

CREATE TABLE t2
(

  c1                         NUMBER,
  c2                         NUMBER

 )

create view tt as
select t1.c1, t1.c2, t2.c2 "c4"
from t1, t2
where t1.c1 = t2.c1

update tt
set c4 = c2
and I get " ORA-00904: invalid column name "

Please tell me why? Received on Fri Mar 31 2000 - 00:51:12 CST