Updating values from one table to another..plz help

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 - 10:29:24 CDT