摘要: 錯誤:1 update account_list2 set PaidIn = select sum(Penalty) from pay_rec where CerID = '1006840113' and Processed = 0,3 Way = '现金'4 where PaidIn = 0.00;正確:1 update account_list a, 2 (select sum(Penalty) as P from pay_rec where CerID = '1006840113' and Processed = 0 group by Pr 阅读全文
posted @ 2012-01-02 19:26 alex4814 阅读(1621) 评论(0) 推荐(0)