他テーブルの集計を他結果をUPDATEする方法
update TableA
set Field1 =
(select sum(Field2) from TableB
where TalbeA.FiledKey = TableB.FieldKey
and FieldDate = '200509'
)
update TableA
set Field1 =
(select sum(Field2) from TableB
where TalbeA.FiledKey = TableB.FieldKey
and FieldDate = '200509'
)