盘点库存入帐SELECT SPBH,SPMCH,DW,PH,SL,XSHW,YZID,ROWID FROM MOVE_STOCK_SOURCE T WHERE T.XSHW NOT LIKE 'A%';DELETE FROM MOVE_STOCK_SOURCE T;-----------------------------UPDATE MOVE_STOCK_SOURCE T SET T.YZID=
--单巷道正序,双巷道倒序SELECT ROWNUM CN,XSHW,XD,JHLJ FROM (select xshw,XD,jhlj from JC_HWZD where MOD(XD,2) =0 and kfbh='LHK' AND SF_SD='否'&
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号