SELECT ahl_school.id,ahl_school.sn,ahl_schooljobs.* FROM
ahl_school INNER JOIN ahl_schooljobs ON ahl_school.id = ahl_schooljobs.sid where ahl_schooljobs.showcommon='1' and ahl_schooljobs.province like '%Xinjiang%' or ahl_schooljobs.province like '%Qinghai%' or ahl_schooljobs.province like '%Gansu%' or ahl_schooljobs.province like '%Mongolia%' or ahl_schooljobs.province like '%Ningxia%' and salary='3000-4000(RMB)' and jobtype='Full time' and teachto='Primary school' order by updatetime desc后面的条件语句都不会执行。无解。。
ahl_school INNER JOIN ahl_schooljobs ON ahl_school.id = ahl_schooljobs.sid where ahl_schooljobs.showcommon='1' and ahl_schooljobs.province like '%Xinjiang%' or ahl_schooljobs.province like '%Qinghai%' or ahl_schooljobs.province like '%Gansu%' or ahl_schooljobs.province like '%Mongolia%' or ahl_schooljobs.province like '%Ningxia%' and salary='3000-4000(RMB)' and jobtype='Full time' and teachto='Primary school' order by updatetime desc后面的条件语句都不会执行。无解。。
[/align]
FROM ahl_school INNER JOIN ahl_schooljobs ON ahl_school.id = ahl_schooljobs.sid
where ahl_schooljobs.showcommon='1'
and (ahl_schooljobs.province like '%Xinjiang%'
or ahl_schooljobs.province like '%Qinghai%'
or ahl_schooljobs.province like '%Gansu%'
or ahl_schooljobs.province like '%Mongolia%'
or ahl_schooljobs.province like '%Ningxia%')
and salary='3000-4000(RMB)'
and jobtype='Full time'
and teachto='Primary school'
order by updatetime desc估计你想要这个效果,注意括号的位置,我加了一对()[align=center]==== 思想重于技巧 ====
[/align]