SELECT j.state, j.district, j.job_id, j.job_name, j.schoollevel
FROM jobs j, schools s
WHERE j.sch_id = s.school_id AND s.active = 1
AND j.state = '#FORM.state#'
AND (1=0
OR subject_areas LIKE '%#Variables.thisArea#%'
)
ORDER BY j.job_name
Please check back often as new jobs are added daily.