RE: Problems with a join...

Wednesday, February 13, 2002 3:35 PM To: mysql Subject: Problems with a join... I'm trying to write a polling application and display the results on an admin screen.. my goal is to show all the answers for the poll questions and display the # of votes for each. The query I have to do t

Problems with a join...

I'm trying to write a polling application and display the results on an admin screen.. my goal is to show all the answers for the poll questions and display the # of votes for each. The query I have to do this is: select pd.ANSWER_TEXT, pr.*, COUNT(*) as NUM from ft_pollresponses as pr right joi