I am trying to get a list of questions stored in a table. There is a second table that has the related answers. When I run the following query I only get the questions, each one listed a numer of times.
How can I list each question once followed by all of the answers for that question?
select name from mp_question A
inner join mp_question_answers B
on A.category = B.question
where A.category = 107