Inner Join in Update Statement in MS Access

 Like this we can use inner join in update statement:
update table1 inner join teble2 on table1.SLNO = table2 .SLNO set table1.VOTER_IDNo = table2.VOTER_IDNo where table2.STATUSTYPE='M'