Update SQL problem
From: Peter Yates <pyates_at_melb.cpr.itg.telecom.com.au>
Date: 1996/01/24
Message-ID: <pyates.822444943_at_cedar>#1/1
Date: 1996/01/24
Message-ID: <pyates.822444943_at_cedar>#1/1
Hi
I'm doing an update to a table using a sub-query and get ORA-01427 single-row subquery returns more than one row. How do I get around this?
update table1
set day=sysdate
where table1.id = (select id from table2 where field2 like
'BLAH');
The select returns more than one row so the update fails.
Thankx in advance
Received on Wed Jan 24 1996 - 00:00:00 CET