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

update a_table a
set pager = (select pager

	       from b_table b
	      where a.firstname = b.firstname
	        and a.lastname = b.lastname
	    )

Second where clause is needed to keep from nulling rows in a_table that are not in b_table.

MN (mirek1_at_hotmail.com) 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?

: I have made both tables unique on firstname and lastname.

: Thank you.

: Eric

--
While Alcatel may claim ownership of all my ideas (on or off the job),
Alcatel does not claim any responsibility for them. Warranty expired when u
opened this article and I will not be responsible for its contents or use.