I am new at this....can someone please tell me what is wrong with this statement?
Thanks
SELECT users.username, users.vote_count, surpool06.surpool_username, surpool06.surpool_team
FROM users
INNER JOIN surpool06
ON users.username = surpool06.surpool_username
UPDATE
users SET vote_count = IF(surpool_team = 'Bears',vote_count-1,vote_count)