UPDATE

[pursuade]

update SEOrderEntry
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 提示不能绑定多个组织，哪位大侠麻烦改下

[LongRui888]

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

[中国风]

AND k.fentryid = a.fentryid 这里不正确

[yooq_csdn]

k.fentryid k 没有这个别名

[Yole]

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