script update 2 table

UPDATE     MatSerial SET   MatSerial.LocationID  = SI2.LocationID       ,MatSerial.DeptID   = SI2.DeptID       ,MatSerial.UserID  = SI2.UserID       --,MatSerial.SiteID  = SI2.SiteID FROM     MatSerial SI INNER JOIN     (select * from MatSerial) as SI2 ON      SI2.MatSRKey = SI.SuperBomKey; -- where SI2.MatSRKey = 1778 or SI.SuperBomKey =1778;