UPDATE Sale
SET    AccountId = a.Id
FROM   Sale s
INNER JOIN Account a
  ON   a.LeadId = s.LeadId

UPDATE Sale
SET    AccountId = Account.Id
FROM   Account
WHERE  Sale.LeadId = Account.LeadId