Help with SQL "Update" query generates "Too few parameters..."

[Guest]

Hello, I'm trying to run a SQL update to a table, but I get "Too few parameters. Expected 2." error. Here is my SQL, can someone please correct it for me?

UPDATE Table1 SET Table1.Field1 = 'MATCH' WHERE
(Table1.Field2 = Table2.Field2) AND
(Table1.Field3 = Table2.Field3)

Thanks much in advance.

 

[Gerald Stanley]

Try
UPDATE Table1 INNER JOIN Table2 ON (Table1.Field2 =
Table2.Field2) AND (Table1.Field3 = Table2.Field3)
SET Table1.Field1 = 'MATCH';

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
Hello, I'm trying to run a SQL update to a table, but I

get "Too few parameters. Expected 2." error. Here is my
SQL, can someone please correct it for me?: