SQL and Access Database is using different SQL Statement?

please give me complete answere

I was create the TableA and TableB (Same Field Name and Data Type)

Update TableB SET sName = TableA.sName FROM TableA, TableB WHERE TableA.SysEmpID = TableB.SysEmpID

In SQL Database, we can use it, but cannot use in Access Database.

Why?

Henry