Update Query

slyvsspy

Registered User.
Local time
Today, 09:23
Joined
Jun 24, 2002
Messages
51
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
 
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;
 

Users who are viewing this thread

Back
Top Bottom