Re: Update Statement ...

The answer is no :-(
[Quoted] You need to select a unique row in the subquery, something like...

update addressbook2 set pin =
(select pin from phonebook where phonebook.primary_key = addressbook2.foreign_key);

Regards,
Andrew.

MN wrote in message <7445ov$duv_at_news1.sjc.in.sel.sony.com>...
>I'm trying compare two table in Oracle and with a firstname and lastname
>matches fill-in a pager pin number.
>
>This is the sql statement I'm running
>
>update addressbook2 set pin =
>(select pin from phonebook where phonebook.firstname=addressbook2.firstname
>and
>phonebook.lastname=addressbook2.lastname)
>where addressbook2.firstname IN (select firstname from phonebook)
>and addressbook2.lastname IN (select lastname from phonebook)
>
>but I get an error message saying:
>ORA-01427: single-row subquery returns more than one row
>
>My question is can I update the table even when there are duplicates in
>the tables. The query runs perfect when both tables are unique.
>
>Thank you for any help.
>
>MN
>
>
Received on Thu Dec 03 1998 - 10:40:36 CET