SELECT apply_info.apply_id, apply_info.course_id, apply_info.stu_id from apply_info INNER JOIN mark_info ON (ABS(mark_info.level2_mark - mark_info.level1_mark) > 20 AND mark_info.define_id = '- 1' OR mark_info.define_id='wzdsgsb') WHERE (apply_info.course_id IN (SELECT course_id from course_info WHERE (course_college = '信息工程学院') AND (course_special = '计算机科学与技术'))) AND (apply_info.ispass = 1)
又符合要求的记录但是查询不出来 谁给看看语法没问题，光这些信息还不够 AND (mark_info.define_id = '- 1' OR mark_info.define_id='wzdsgsb')) WHERE (apply_info.course_id IN
