Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Update rows in a table get ora-error 01779
Hi,
I'm trying to update a table. The following sql still doesn''t work I get the error: ORA-01779: cannot modify a column which maps to a non key-preserved table".
However both are base tables and have their primary keys.
Much appreciate any help!
update (
select tab1.x tobeupdated,
tab2.y tobequal
from tab1, tab2
where tab1.field1x = tab2.field2x
and tab1.field1y = tab2.field2y
)
set tobeupdated = tobequal
Thanks,
JC Received on Mon Jul 15 2002 - 18:01:13 CDT