update MasterTbl set TotalX = (select sum(X) from DetailTbl where DetailTbl. MasterID = MasterTbl.ID) update MasterTbl set TotalY = (select ...
www.google.com.tw