This is the query I am using:
In the line SET [RI Number] = j.[RI Number] I getCode:UPDATE t SET [RI Number] = j.[RI Number] FROM Members_20141022 t INNER JOIN [RI numbers] j ON (j.[Last Name] = t.[Last Name]) AND (j.[First Name] = t.[First Name])
(missing operator).[RI Number]
I want to Update the [RI number] in the Members_20141022 table using the
[RI Number] in the [RI numbers] table WHERE the [First Name] and [Last Name] match.
Suggestions welcomed...
Todd