About Update Sql statement in Access97

[Arron]

In Excel 97+dao360.dll
In Access97,I use sql statement :"UPDATE
TMP1 inner join tmp2 on tmp1.id=tmp2.id set
tmp1.name=tmp2.name"
but it returns error message.
/Join expression not supported. (Error 3296)/

In SQL Server ,I write "Update tmp1 set
tmp1.name=tmp2.name from tmp2 where tmp1.id=tmp2.id"
to gain my goal.And it's correct.

My question is :How should I change my sql statement in
Access97 to gain the same goal?

Thank you~~~

 

[david epsom dot com dot au]

use more brackets.
This may work.
....on (tmp1.id=tmp2.id ) ...


Also, you probably need to have a unique index on one side of the join

(david)

 

[Van T. Dinh]

What has Excel97 got to do with your question?

Van T. Dinh
MVP (Access)