On Tue, Jul 6, 2021 at 5:05 PM Pantelis Theodosiou <ypercube@gmail.com> wrote:
Transactions is referenced twice, once without correlation and secondly with correlation.
Yeah, the USING clause of DELETE is basically an INNER JOIN. If you need an ANTI-JOIN you can write that via NOT EXISTS just like you would in a normal SELECT query. You don't get the option to write an anti-join using a left join and testing for null.