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

Try

Update A set pager =
(select pager from B where B.fname=A.fname) where A.fname IN (select fname from B);

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 - 11:36:17 CDT