UPDATING error

From: Joseph Kagume Ngari <ngari_at_unbc.ca>
Date: Wed, 23 Jun 1999 21:05:34 -0700
Message-ID: <3771AE8E.23D5B88@unbc.ca>

if you read the last post sorry for nto telling you that i am using oracle 8

update (select * from defree where project=3 and version=2 and id=5) DT1

(select * from deftree where project=3 and version=2 and id=DT1.parent)
DT2
(select * from deftree where project=3 and version=2 and id=DT1.child)
DT3
SET DT2.child=DT1.child and DT3.parent=DT1.parent;

Please respond to ngari_at_unbc.ca Received on Wed Jun 23 1999 - 23:05:34 CDT