I need help w an Update Query

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Dave" <davekstl@xxxxxxxxxxx>
Date: Mon, 11 Apr 2005 07:37:28 -0500

I have two Tables, both tables have the same 3 Fields EmplID, LName, FName.

Table One only has values for the EMPLID and is missing the LName & FName
values. Table Two has all of the information needed.

I need to Update the LName & FName in Table One from the LName & FName in
Table Two..

I have tried various methods and cannot get the results I am looking for.
This is my first Update using 2 tables.

Dave

.

Follow-Ups:
- Re: I need help w an Update Query
  - From: Jeff Boyce

Prev by Date: Re: SQL Sum producing rounding error on currency fields
Next by Date: Re: Find Numbers in Text Field
Previous by thread: SQL Sum producing rounding error on currency fields
Next by thread: Re: I need help w an Update Query
Index(es):
- Date
- Thread

Relevant Pages

Re: Form wont remember last value
... "Ken Snell (MVP)" wrote: ... "I am using the LName and FName parameters as the Control Source for ... Report SQL: ...
(microsoft.public.access.formscoding)
Re: Table design and Normalization
... All these people share the facts that they have FName, LName, ..., so having ... > DteBrth ... > SocSecurNumb ...
(microsoft.public.access.tablesdbdesign)
Re: Problem with DBD::Oracle on OS X
... "state, len, rcntelno, lname, fname, instdate, ". ... ID, mrf_group, t.discodate FROM customer@teadprd c inner join ...
(perl.dbi.users)
Re: Problem with DBD::Oracle on OS X
... "state, len, rcntelno, lname, fname, instdate, ". ... ID, mrf_group, t.discodate FROM customer@teadprd c inner join ...
(perl.dbi.users)
Problem with DBD::Oracle on OS X
... sqlPlus works just fine and I would have considered by DBD::Oracle install to be ok, ... "state, len, rcntelno, lname, fname, instdate, ". ...
(perl.dbi.users)