About Update Sql statement in Access97

  • Thread starter Thread starter Arron
  • Start date Start date
A

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~~~
 
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)
 
Back
Top