Update Query

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-

elli wrote:
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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com