Hi Mike or Scott,
I am trying to do an update query to set the status of a quote to closed if it has been converted to a sales order.
I tried the following without success. Could you help please.
update qo_main
set status = 1
WHERE QO_History.InvoiceHistoryID in (SELECT so_main.SourceQuoteHistoryID FROM SO_Main)
JOIN QO_Main on QO_Main.InvoiceID = QO_History.InvoiceID