Access UPDATE query to SQL Server

How do I convert an Access UPDATE query to SQL Server?


Access SQL

• UPDATE Books INNER JOIN UpdateList
     ON Books.ISBN = UpdateList.ISBN
     SET Books.Price = [Updatelist].[price]

SQL Server

• UPDATE Books
      SET Books.Price = [Updatelist].[price]   
      FROM Books INNER JOIN UpdateList
         ON Books.ISBN = UpdateList.ISBN