感觉比较神奇,自己也没有完全搞懂
update
customer1 ,si_order_main
set Customer_BuyNum = (select SUM(MainOrder_BuyNums) from si_order_main
where MainOrder_UserID=Customer_ID and MainOrder_IsSuccess=1 group by MainOrder_UserID)
where MainOrder_UserID=Customer_ID and MainOrder_IsSuccess=1 ;