Update query using Subquery in Sql Server ... you can join both tables even on UPDATE statements, UPDATE a SET a.marks = b.marks FROM ...
www.google.com.tw