I wrote the following example in SQL Server 2005:
delete from arledger
from arledger
inner join arinvoice on arinvoice.arinvoiceid = arledger.invoicenumber
where arinvoice.brokersaleid = 2259
Nothing complicated. Just note line 2 where the FROM clause is repeated.
2 comments:
I always, always, get nervous when JOINs on my DELETEs get complex.
Post a Comment