sqlÓï¾äÇóÖú - MS-SQL Server / »ù´¡Àà

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)

ÓÖ·ûºÏÒªÇóµÄ¼Ç¼µ«ÊDzéѯ²»³öÀ´
Ë­¸ø¿´¿´

---

Ó﷨ûÎÊÌ⣬¹âÕâЩÐÅÏ¢»¹²»¹»

---

AND (mark_info.define_id = '- 1' OR mark_info.define_id='wzdsgsb'))
WHERE (apply_info.course_id IN

---

ÒýÓÃ

ABS(mark_info.level2_mark - mark_info.level1_mark) > 20 AND mark_info.define_id = '- 1' OR mark_info.define_id='wzdsgsb'

-->ÕâÀïÐèÒª¼Ó¸öÀ¨ºÅ.²»ÖªµÀÄãÔõô¼Ó?
(ABS(mark_info.level2_mark - mark_info.level1_mark) > ¡­¡­

¹»×ÐϸµÄ

---

SQL code:
Õë¶ÔÌõ¼þÒ»²½Ò»²½µÄɸѡ£¬
²»È»¿ÉÒÔ·¢Ò»Ð©Êý¾Ý¹ýÀ´£¬

---

°ïÄ㶥°É