Modifiable join view

Hi all, just a little problem I'm having but can't see an easy solution. Goes something like this, hopefully this is not too abstract:

table test1 ->
cola
colb
colc_1

unique index on cola and colb

table test2 ->
cola
colb
colc_2
cold_2

unique index on cola, colb, colc_2

create view view1 (cola, colb, cold_2)
as select a.cola, a.colb, b.cold_2
from test1 a, test2 b

where a.cola = b.cola
and   a.colb = b.colb
and   colc_2 = 0

my update then is

update view1 set colc_1 = 'X'
where colb = 'ACB'
and colb = 'DEF'

the error then is:
ORA-01779: cannot modify a column which maps to a non key-preserved table

The web page:
http://www-wnt.gsi.de/oragsidoc/doc_804/appdev.804/a58241/ch4.htm#978 seems pretty descriptive but I'm just not getting it.

Can anyone see whats required to make this work?

Thanks greatly for any help on this! Received on Thu Oct 25 2001 - 03:43:19 CDT