UPDATE Kala
SET AkharinArzId=(SELECT top(1) ArzID FROM RadifSanad LEFT OUTER JOIN Sanad ON RadifSanad.SanadID=Sanad.ID WHERE KalaID=Kala.ID AND Sanad.Type='FactorKharid' ORDER BY Sanad.ID DESC)