Delete using INNER JOIN with SQL Server

Syntax

DELETE          TP
FROM            TransactionPayments TP
INNER JOIN      Transactions AS T ON T.TransactionID = TP.TransactionID
WHERE           CONVERT(DATE, T.TransactionDate) = '2024-12-07'