一次更新出库批次(多条入库,一条出库)
----查找重复流水SELECT * FROM (select a.docno,b.pluid,sum(B.QTY) AS QTY,COUNT(1) AS DCNTfrom doc01bf a,doc01dt bwhere a.docno=b.docno and a.ctyp=3 and a.valid=1group by a.docno,b.pluid) A Left o...
注册时间:2009-02-13