Since you did not include what you have tried. Try using an inner join BEGIN TRAN DELETE tblResultNotes FROM tblResultNotes INNER JOIN tblResults ON tblResultNotes.ResultID = tblResults.ResultID ROLLBACK TRAN Look up BEGIN TRAN to see what to replace ROLLBACK TRAN with to commit the delete.