delete Update inner join 的使用

sql server下应该这么写
    delete from a from a inner join b on a.id=b.id

而Access中写为
    delete from a inner join b on a.id=b.id


update 语句也不同
    Access
        update  a inner join b on a.id=b.id set a.pwd=b.pwd 
   
   SQL Server
        update a set a.pwd=b.pwd from a inner join b on a.id=b.id