I did max(pin) and it worked. n/m

KeyStroke (Jack L. Swayze Sr.) wrote in message <3665EB3B.950AB2BF_at_Feist.Com>...
>not being there, I can't tell if this will work or not but try this:
>
>update addressbook2 set pin =
>(select pin from phonebook where phonebook.firstname=addressbook2.firstname
>and
>phonebook.lastname=addressbook2.lastname)
>where (addressbook2.firstname, addressbook2.lastname) IN (select firstname,
>lastname from phonebook)
Received on Thu Dec 03 1998 - 08:46:49 CST