摘要:
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. 阅读全文