Update Query

  • Thread starter Thread starter elli
  • Start date Start date
E

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-
 
elli said:
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-
Click to expand...

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