FlexiCoder Blog

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

Category: SQL Server by flexicoder