Re: Stored Procedures

[Michael Smith]

I got the answer from ChatGPT. Its not code like I have seen before, but it works.

DELETE FROM Invoices02
WHERE Invnbr IN (
SELECT Invnbr FROM (
SELECT Invnbr FROM Invoices02
WHERE Check01 = 1
GROUP BY Invnbr
) AS subquery
);

Mike