2.1w+
社区成员
UPDATE
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 提示不能绑定多个组织，哪位大侠麻烦改下
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 提示不能绑定多个组织，哪位大侠麻烦改下
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
Yole 2015-12-07
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
yooq_csdn 2015-12-07
k.fentryid
k 没有这个别名
中国风 2015-12-07
AND k.fentryid = a.fentryid
这里不正确
阳泉酒家小当家 2015-12-07
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