Error on SQL query on Access Database
===

I am not very familiar with working with MS Access but i can write my queries in mysql and postgres

Here is the problem

    UPDATE school_new 
      set school_new.school_id = school.[School ID], school_new.school_id = school.[School ID]
    FROM school_new
    INNER JOIN school on school_new.school_name = school.[School Name]

And i get this error and i can't figure out what is the problem

    Syntax error (missing operator) in query expression 'school.[School ID] FROM school_new
    INNER JOIN school on school_new.school_name = school.[School Name]