Untitled

select A.answer, COUNT(V.answer_id) as votes from poll_answers A, poll_votes V where A.poll_id = V.poll_id and A.poll_id = 4 and A.id = V.answer_id group by A.answer