SQLite下Update无法Join解决办法

SQLite下执行update语句无法像SQL Server下实现join，例如：

update Product set Product.StockNumber =Product.StockNumber-BuyNumber 
from Product join OrderListDetail on (Product.ID =OrderListDetail.ProductID) 
     join OrderList on (OrderList.ID=OrderListDetail.OrderListID)
where OrderListID='55170b21-58d2-4e6f-8821-f0a56fed9b52'

解决办法：换用replace，改写如下

replace into Product 
(ID,Caption,Number,ProjectTypeCaption,BuyPrice,MeasureUnit,StockNumber)
select Product.ID,Product.Caption,Product.Number,Product.ProjectTypeCaption,Product.BuyPrice,StockNumber-BuyNumber 
from Product join OrderListDetail on (Product.ID =OrderListDetail.ProductID) 
     join OrderList on (OrderList.ID=OrderListDetail.OrderListID)
where OrderListID='55170b21-58d2-4e6f-8821-f0a56fed9b52'

注意：Product表里的每个列都会重新赋值

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!