Update Query

[elli]

What's wrong with my query?

UPDATE InventointiPohja INNER JOIN Tiedot ON InventointiPohja.ID = Tiedot.ID
Set Tiedot.[*] = InventointiPohja.[*]
WHERE InventointiPohja.OK=-1;

When I run it , error message says that there must be update query to be
used....

totally confused -elli-

 

[Rick Brandt]

What's wrong with my query?

UPDATE InventointiPohja INNER JOIN Tiedot ON InventointiPohja.ID =
Tiedot.ID Set Tiedot.[*] = InventointiPohja.[*]
WHERE InventointiPohja.OK=-1;

When I run it , error message says that there must be update query to
be used....

totally confused -elli-

I don't believe you can use the * in an update query. Try listing all if the
fields individually.