Update Query with inner join in Sql Server
In SQL server query, you can join two tables in update query. You can user inner join, left outer join or right outer join in WHERE clause for filter the data in update query.
The following query is the syntax of the UPDATE JOIN clause .
SET c.Car_NavPath='New-Cars/' +comp.Comp_Code
FROM Car_CarMaster AS c INNER JOIN
Car_Company AS comp ON c.Comp_Id = comp.Comp_Id INNER JOIN
Car_Model AS m ON c.Model_Id = m.Model_Id