使用 SQL 的 MS Access 嘗試關注這篇文章——
我的目標是使用tbl_line_items.Order_Numberandtbl_line_items.Line_Number作為主鍵，獲取列 valuetbl_line.items_Product_Line并將其更新為tbl_MTO_vs_ETO.ProductLine.
基本上，我想獲得具有相應產品線和訂單號的產品線，并將其插入到 MTO 與 ETO 表中。
當前代碼：
UPDATE tbl_line_items INNER JOIN tbl_MTO_vs_ETO ON (tbl_line_items.Order_Number = tbl_MTO_vs_ETO.Order) AND (tbl_line_items.Line_Number = tbl_MTO_vs_ETO.Line) AND (tbl_line_items.Product_Line = tbl_MTO_vs_ETO.ProductLine)
SET tbl_MTO_vs_ETO.ProductLine = [tbl_MTO_vs_ETO].[ProductLine]=[tbl_line_items].[Product_Line];
我的查詢追加，但沒有回傳任何內容（“您將要更新 0 行”）。我相信我應該使用 UPDATE 陳述句，因為記錄已經存在，我最近剛剛添加了該產品線列以進行進一步過濾。
對于nbk——
我運行了一個 SELECT 和 JOIN 查詢，并且能夠成功提取分片順序和行號，并找到每條記錄的產品線。現在的問題是，如何將其轉換為 UPDATE 查詢？
代碼：
SELECT tbl_line_items.Product_Line, tbl_line_items.Order_Number, tbl_line_items.Line_Number
FROM tbl_MTO_vs_ETO INNER JOIN tbl_line_items ON (tbl_MTO_vs_ETO.line = tbl_line_items.Line_Number) AND (tbl_MTO_vs_ETO.Order = tbl_line_items.Order_Number);
uj5u.com熱心網友回復：
你SELECT有兩個條件
SELECT
tbl_line_items.Product_Line,
tbl_line_items.Order_Number,
tbl_line_items.Line_Number
FROM
tbl_MTO_vs_ETO
INNER JOIN
tbl_line_items ON (tbl_MTO_vs_ETO.line = tbl_line_items.Line_Number)
AND (tbl_MTO_vs_ETO.Order = tbl_line_items.Order_Number);
但你UPDATE有三個
UPDATE tbl_line_items
INNER JOIN tbl_MTO_vs_ETO
ON (tbl_line_items.Order_Number = tbl_MTO_vs_ETO.Order) AND (tbl_line_items.Line_Number = tbl_MTO_vs_ETO.Line) AND (tbl_line_items.Product_Line = tbl_MTO_vs_ETO.ProductLine)
SET tbl_MTO_vs_ETO.ProductLine = [tbl_MTO_vs_ETO].[ProductLine]=[tbl_line_items].[Product_Line];
必須滿足這三個條件UPDATE才能發生
所以使用
UPDATE
tbl_MTO_vs_ETO
INNER JOIN
tbl_line_items ON (tbl_MTO_vs_ETO.line = tbl_line_items.Line_Number)
AND (tbl_MTO_vs_ETO.Order = tbl_line_items.Order_Number);
SET tbl_MTO_vs_ETO.ProductLine = [tbl_MTO_vs_ETO].[ProductLine]=[tbl_line_items].[Product_Line];
使UPDATE作品
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/453961.html