I am getting an SQL error when I attempt to "add 10 voters." Below is the error message. The problem seems to be after the "is null or not exists." I am runing windows 2000, MySql 4.0.18.

Any help would be greatly appreciated.

-BB

------------------------------------------------------------
Error message was:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'exists (select vtj1.voter_id from ak_voterteamjob vtj1 left joi

------------------------------------------------------------
SQL was:
select distinct v.id from ak_voter v left join ak_voterteamjob vtj on (vtj.voter_id = v.id) left join ak_teamjob tj on (tj.id = vtj.teamjob_id) left join ak_team t on (t.id = tj.team_id) left join ak_residence r on (r.id = v.residence_id) where (vtj.id is null or not exists (select vtj1.voter_id from ak_voterteamjob vtj1 left join ak_teamjob tj1 on tj1.id = vtj1.teamjob_id left join ak_team t1 on t1.id = tj1.team_id where t1.operation_id = 2) ) order by r.number desc limit 0,30