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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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?:
 
Back
Top