摘要: begin tran-- select sum(q) as stock_q,sum(q * tax_entry_price) as tax_entry_a,sum(q * a.retail_price) as tax_retail_a from stk_fifo s,article awhere s.aid=a.aidselect sum(stock_q),sum(tax_entry_a) as tax_entry_a,sum(tax_retail_a) as tax_retail_a from article_storespaceupdate article_storespaceset a. 阅读全文
posted @ 2013-06-25 16:35 kuailewangzi1212 阅读(238) 评论(0) 推荐(0) 编辑