Inner join and update statement in Access
Posted on 2009-05-11
I saw below SQL statement in an Access project:
db.Execute "UPDATE tableA INNER JOIN tableB" _
& "ON tableA.NUMBER = tableB.Number_ASC" _
& "Set tableA.field1 = tableB.field1
I don't have much experience in Access, could anyone explain this query? Is it a common practice in Access? BTW, I know inner join, but am just not used to the usage of the update statement here. Thanks.