34,594
社区成员
发帖
与我相关
我的任务
分享
update Inventory_Tbl set InveQty=InveQty-a.OIQuantity, SellQty=SellQty+a.OIQuantity
where PIID in (select a.PIID from OrderItems_Tbl a where OrderNO='20110403004')
update Inventory_Tbl
set InveQty=InveQty-a.OIQuantity, SellQty=SellQty+a.OIQuantity
from Inventory_Tbl,OrderItems_Tbl a
where a.PIID=Inventory_Tbl.PIID
and Inventory_Tbl.OrderNO='20110403004'
update a set InveQty=InveQty-b.OIQuantity, SellQty=SellQty+b.OIQuantity
from Inventory_Tbl a,(select PIID,OIQuantity from OrderItems_Tbl a where OrderNO='20110403004')b
where a.PIID=b.PIID
select a.PIID from OrderItems_Tbl a where OrderNO='20110403004'
--这条查出来是有多条语句的--