SQL: Update with values from another table

UPDATE Log<br /> SET Username = u.Username, Name = u.Name<br /> FROM Users u<br /> Where u.Id = userid

Source: codesnippets.joyent.com