请各位老师帮助写一个一次性出库的代码！谢谢

点击下载此附件

 供参考        表的副本删除掉

减少库存：

UPDATE tblProduct_Stock_Remote, tblTemp SET tblProduct_Stock_Remote.Real_Qty = TBLPRODUCT_STOCK_REMOTE.REAL_QTY-TBLTEMP.RQST_QTY, tblProduct_Stock_Remote.Available_Qty = TBLPRODUCT_STOCK_REMOTE.AVAILABLE_QTY-TBLTEMP.RQST_QTY
WHERE tblProduct_Stock_Remote.ITEM=tblTemp.ITEM;

INSERT INTO tblStockIn_Out_Remote ( Item, In_Out_Date, [ID Motive], In_Out, Quantity, [Note] )
SELECT tblTemp.ITEM, tblTemp.In_Out_Date, tblTemp.[ID Motive], tblTemp.In_Out, tblTemp.RQST_QTY, tblTemp.Note
FROM tblTemp;