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

R

rotor

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.
 
G

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
Click to expand...
get "Too few parameters. Expected 2." error. Here is my
SQL, can someone please correct it for me?:
 
Top