UPDATE

pursuade 2015-12-07 10:13:00
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 提示不能绑定多个组织,哪位大侠麻烦改下
...全文
134 点赞 收藏 4
写回复
4 条回复
切换为时间正序
当前发帖距今超过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 这里不正确
回复
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
回复
发帖
疑难问题
创建于2007-09-28

2.1w+

社区成员

MS-SQL Server 疑难问题
申请成为版主
帖子事件
创建了帖子
2015-12-07 10:13
社区公告
暂无公告