Sql update with nested select

Toad for SQL Server
1

I have created a nested select query that returns records I need to inactivate on APVEMAST table. How can I add update to it so it updates only the records returned in the select. Here is the query:
select x.VENDOR, x.CHK_DT from
(select p.VENDOR, max(p.CHECK_DATE) as CHK_DT
from
(select CHECK_DATE, v.VENDOR from APPAYMENT a, APVENMAST v where v.VEN_CLASS='ONE' and VENDOR_STATUS='A' and v.VENDOR=a.VENDOR) p
group by p.VENDOR) x
where (x.CHK_DT < '1/1/2023' and CHK_DT != '1/1/1753') order by x.VENDOR

Thank you

2

Question is outside the scope of the forum, in that you're asking a how-to question involving SQL, and not about Toad itself.

However, trying to be helpful here... there are many ways to accomplish what you're trying to do in the SQL language...here's one link (many more such links exist) that you can use to get some insight...
https://www.sqlshack.com/how-to-update-from-a-select-statement-in-sql-server/

Hope this helps.

3

Thank you, Gary, I will check it out.
But I do use toad for SQL and that's why I chose it.

4

Of course, and thanks for choosing Toad. It's just that there are several ways (at least) to accomplish your goal with the SQL language. Once you light on an appropriate method, then Toad will gladly execute your logic.