The following example shows how to perform a delete using an inner join
DELETE
a
FROM
StatementlineassociatedPayment AS a
INNER JOIN
rebatePatientStatementLine AS b
ON
a.StatementlineId = b.Id
INNER JOIN
rebatePatientSummary AS c
ON
b.summaryId = c.Id
WHERE
c.IssueStatus <> 2