Re: Update Statement ...

Try
...
select max(pin) from phonebook where
phonebook.firstname=addressbook2.firstname ....

Do you know , which record is correct?

Use max or min - if your base is consistent, max(pin)=min(pin) ????

MN napisa³(a) w wiadomo¶ci: <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 - 13:31:09 CET