56,682
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE UpdateSalesToResult(IN SalesDate varchar)
BEGIN
UPDATE list_result t
INNER JOIN sales s
ON t.date_=s.date_ and t.storecode=s.storecode and t.itemcode=s.itemcode
SET t.StockQty=s.ystock,t.SalesQty=s.ysales
WHERE s.date_=SalesDate
END;
CREATE PROCEDURE UpdateSalesToResult(IN SalesDate varchar)
BEGIN
UPDATE list_result t
INNER JOIN sales s
ON t.date_=s.date_ and t.storecode=s.storecode and t.itemcode=s.itemcode
SET t.StockQty=s.ystock,t.SalesQty=s.ysales
WHERE s.date_=SalesDate
END;
变成
CREATE PROCEDURE UpdateSalesToResult(IN SalesDate varchar)
BEGIN
UPDATE list_result t
INNER JOIN sales s
ON t.date_=s.date_ and t.storecode=s.storecode and t.itemcode=s.itemcode
SET t.StockQty=s.ystock,t.SalesQty=s.ysales
WHERE s.date_=SalesDate;
END
就好啦