I have users table in that lot of records in that one i need to update only FirstName,Lastname,MiddleName in that from another table
i have 600000 records in one table and 580000 records in another table.i have to update only 580000 records in users table??How to write query for this >???
UPDATE tgt SET FirstName =src.FirstName ,MiddleName = src.MiddleName ,lastname = src.lastName FROM TargetTable tgt INNER JOIN SourceTable src ON <whatever the link is between the tables>
Jim
Everyday I learn something that somebody else already knew
How to update use set of Records
Posted - 11/16/2012 : 08:34:31
