22,301
社区成员




update a--SEOrderEntry 这里改成a
set a.fauxcommitqy=b.fauxqty,
a.fcommitqty=b.fqty,
a.fseccommitqty=b.fsecqty
from seorderentry a,icstockbillentry b,ICStockBill c
where c.FBillNo like 'KK-%' and c.FInterID=b.finterid and c.FTranType=21 and
b.fsourcetrantype=81
and b.fsourceinterid=a.finterid and k.fentryid=a.fentryid
and a.FCommitQty=0 and a.FStockQty<>0
update SEOrderEntry
set fauxcommitqy=b.fauxqty,
fcommitqty=b.fqty,
fseccommitqty=b.fsecqty
from seorderentry a,icstockbillentry b,ICStockBill c
where c.FBillNo like 'KK-%' and c.FInterID=b.finterid and c.FTranType=21 and
b.fsourcetrantype=81
and b.fsourceinterid=a.finterid and k.fentryid=a.fentryid
and a.FCommitQty=0 and a.FStockQty<>0