Update Query

[slyvsspy]

I have two tables. 1 large table called "Voters" and 1 small table called "Import". I want to update "Voters" from "Import". It should know which field to update by a field in both tables called "VOTERID".

Can anyone tell me what I need to put in the "update to" part of the query?

Thanks

 

[Alexandre]

Ex: assuming that you want to update the field Name in Voters from Name in Import where records have the same ID1

UPDATE Import
INNER JOIN Voters ON Import.ID1 = Voters.ID1
SET Voters.Name = Import.Name;