两种方式:

• 使用ON DELETE CASCADE设置外键约束.
• 使用多表DELETE语句.

• Set up foreign key constraints with ON DELETE CASCADE.
• Use a multiple-table DELETE statement.

尝试一下:

DELETE tblSurvey, tblQuestion, tblAlt, tblAnswers 
FROM tblSurvey
JOIN tblQuestion ON tblsurvey.surveyID = tblQuestion.surveyID
JOIN tblAlt ON tblQuestions.questID = tblAlt.questID
JOIN tblAnswers ON tblAlt.altID = tblAnswers.answerAltID 
WHERE tblSurvey.surveyID = 1