View Single Post
  #3 (permalink)  
Old May 26th, 2006, 12:51 AM
ramk_1978 ramk_1978 is offline
Authorized User
Join Date: Oct 2004
Location: Hyderabad, Andhra Pradesh, India.
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts


I am using SQL Server 2000 for this and the reply that i got is:

update table2 set firstname=table1.firstname, lastname=table1.lastname from table1,table2
where table1.eid=table2.eid

Reply With Quote