SELECT apply_info.apply_id, apply_info.course_id, apply_info.stu_id
FROM apply_info INNER JOIN
_info ON (ABS(_info.level2_ - _info.level1_) > 20 AND _info.define_id = '- 1' OR _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)又符合要求的记录但是查询不出来
谁给看看
FROM apply_info INNER JOIN
_info ON (ABS(_info.level2_ - _info.level1_) > 20 AND _info.define_id = '- 1' OR _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)又符合要求的记录但是查询不出来
谁给看看
WHERE (apply_info.course_id IN
(ABS(_info.level2_ - _info.level1_) > 20 AND _info.define_id = '- 1') OR _info.define_id='wzdsgsb'ABS(_info.level2_ - _info.level1_) > 20 AND (_info.define_id = '- 1' OR _info.define_id='wzdsgsb')另:
apply_info,_info这两表用什么关联?只用on后面的条件不行,貌似成迪卡尔积了.