Re: Update Statement ...
From: Andrea Cannaos <Andrea.Cannaos_at_deagostini.it>
Date: Thu, 03 Dec 1998 18:05:54 +0100
Message-ID: <3666C4F2.8B6C1EC3_at_deagostini.it>
Date: Thu, 03 Dec 1998 18:05:54 +0100
Message-ID: <3666C4F2.8B6C1EC3_at_deagostini.it>
Andrew Kirkbride wrote:
> The answer is no :-(
> 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.
Or you can use
update addressbook2 set pin =
(select MAX(pin) from phonebook where phonebook.firstname=addressbook2.firstname
and
phonebook.lastname=addressbook2.lastname)
-- \\\\//// &( oo )& ========oOO==(__)==OOo======== | | |Andrea.Cannaos_at_deagostini.it| | | ============================== || || (__) (__)Received on Thu Dec 03 1998 - 18:05:54 CET