Sponser Link

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 .

UPDATE c

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