ORA-01779: cannot modify a column which maps to a non key-preserved table

From: April <PrivateBenjamin_at_hushmail.com>
Date: 28 Oct 2002 08:51:59 -0800
Message-ID: <54df0379.0210280851.19f6c806@posting.google.com>

Hi,

I am trying to update a field (employee#)in a table when the same field (employee#) changes in another table using the sql below.

UPDATE (
SELECT
  c.Employee# rel_empnum,
  a.EMPLOYEE# inv_empnum
FROM

  vw_tblInvestments a,
  vw_tblSub_Investments b,
  vw_TBLRELEASES c

WHERE
  a.INVESTMENT# = b.INVESTMENT# AND
  b.RELEASE# = c.RELEASE#)
SET rel_empnum = inv_empnum

the primary keys are:

Investment# - tblInvestments

Investment#     - tblSub_Investments
Subinvestment#  - tblSub_Investments
Release#        - tblSub_Investments

Release#        - tblReleases

• there could be multiple release# for each investments

why am I receiving the message "ORA-01779: cannot modify a column which maps to a non key-preserved table" when all tables have primary keys and are joined through those keys?

Or is there a different way to write the sql statement?

Thanks for your help
April Received on Mon Oct 28 2002 - 10:51:59 CST