How do I convert an Access UPDATE query to SQL Server?
Access SQL
UPDATE Cars INNER JOIN UpdateList
ON Cars.Parts = UpdateList.Parts
SET Cars.Price = [Updatelist].[price]
SQL Server
UPDATE Cars
SET Cars.Price = [Updatelist].[price]
FROM Cars INNER JOIN UpdateList
ON Cars.Parts = UpdateList.Parts