Re: UPDATE QUERY
From: Ananth Ram <arama_at_amp.com>
Date: 1996/09/13
Message-ID: <51bqin$qg8_at_nexus.amp.com>#1/1
Date: 1996/09/13
Message-ID: <51bqin$qg8_at_nexus.amp.com>#1/1
Hi Dave,
Try this.
Update part_table_A a set cost_a = ( select cost_b from part_table_B b
where a.part# = b.part#).
In this Part# should be the primary/Unique key otherwise you will get ORA-1427 - Single-row returuns more than one row ... Error.
Ananth Ram Received on Fri Sep 13 1996 - 00:00:00 CEST