--状态:正常;审核通过;排除上传题 SELECT ShiTiALL.* FROM dbo.Exam_e_QuestionInfo AS ShiTiALL INNER JOIN dbo.Exam_e_QuestionType AS LeiXingALL ON LeiXingALL.QuestionTypeID = ShiTiALL.QuestionTypeID WHERE 1=1 AND LeiXingALL.QuestionTypeName not LIKE '%上传%' and q.QuestionDesc not like '%