I need some help with writing an SQL query.

I have 2 tables with some duplicate data that I would like to associate with each other.
Table1 - ID-Group1
ID - primary key
FirstName
LastName
Address
City
State
Zip


Table2 - IDGroup2
ID - primary key
FirstName
LastName
Address
City
State
Zip
Table1ID



There are a large number of duplicate Firstname/lastName/add/city/state/zip in Table1 and Table2, but they have different ID's.

Is there a way to write a query to look for matches between the tables and then update Table1ID on the appropriate Table2 record?

thanks

which db are you using ? Mysql, postgresql, ms sql server, oracle, db2 ? And I am not sure I understand you correctly ? You want to copy the id of the 1st table to the second when the names match? Or do you want to sync the names/addresses for a given id if they are different ?

Update IDGroup2 Set Id = IDGroup1.Id from IdGroup1
Where IdGroup1.FirstName = IDGroup2.FirstName AND
IdGroup1.LastName = IdGroup.LastName

And you can add more conditions.