Re: Updating values from one table to another..plz help

Sorry, left out the firstname and lastname thing. update A set pager =
(select pager from B where B.fname = A.fname and B.lname=A.lname) where fname||lname IN (select fname||lname from B);

Hope this helps...

MN wrote:

> Hi,
>
> I have two tables. Table A contains four columns:
> firstname,lastname, pager and phone; table B contains firstname,
> lastname and pager. I want to transfer all pager numbers
> from table B to A based on the matching firstnames
> and lastnames. I've been working for days on this query
> but can't get it to work. Can someone please help me out ?
> How would the "update A set pager =..." look?
>
> Thank you.
>
> Eric
Received on Wed Oct 07 1998 - 12:07:14 CDT