Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Updating values from one table to another..plz help
Doug,
Thank you. That helped me so much.
Doug Cowles wrote in message <361B9880.5586E38C_at_i84.net>...
>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 - 12:51:24 CDT