you can join both tables even on UPDATE statements, UPDATE a SET a.marks = b.marks FROM tempDataView a INNER JOIN tempData b ON a.Name = b.Name.
確定! 回上一頁