Update Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

elli - 25 Feb 2006 09:02 GMT

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-

Reply to this Message

Rick Brandt - 25 Feb 2006 13:06 GMT

> What's wrong with my query?
>
[quoted text clipped - 6 lines]
>
> totally confused -elli-

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

Signature

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

Reply to this Message