UPDATE dữ liệu với INNER JOIN

UPDATE     a

SET        CarMaker = b.Maker

FROM       tblOne AS a INNER JOIN

          tblTwo as b ON a.CarName = b.Model