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
UPDATE Log<br /> SET Username = u.Username, Name = u.Name<br /> FROM Users u<br /> Where u.Id = userid Source: codesnippets.joyent.com