我有以下查詢：
SELECT
Quotes.quoteID, Orders.orderID, Orders.invoiceID,
Quotes.parentOrderID AS QuoteParent, Orders.parentOrderID AS OrderParent
FROM
Quotes
INNER JOIN
Orders ON Quotes.orderID = Orders.orderID
我需要用OrderParent列中的有效（非空）值填充所有QuoteParent列。
如何撰寫UPDATE查詢？
uj5u.com熱心網友回復：
怎么樣：
UPDATE o
SET parentOrderID = q.parentOrderID
FROM dbo.Orders o
INNER JOIN Quotes q ON o.OrdersID = q.OrderID
WHERE o.parentOrderID IS NULL
AND q.parentOrderID IS NOT NULL
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/414988.html
標籤：