View Single Post
  #2 (permalink)  
Old May 25th, 2006, 02:14 PM
Jack Britton Jack Britton is offline
Registered User
 
Join Date: May 2006
Location: Renton, Washington, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ramkumar:

Try this SQL statement:

UPDATE TBL, tblEmployees SET TBL.Firstname = TBL!Firstname, TBL.Lastname = [TBL]![Lastname]
WHERE (((TBL.Firstname)=[tblEmployees]![FirstName]) AND ((TBL.Lastname)=[tblEmployees]![LastName]));

TBL was a test table I set up in Access to make sure it worked. It does. I hope this helps. I don't know what type of RDBMS you are using but this does work in Access.

Thanks,
Jack Britton

Reply With Quote