title: Group_concat use?
body: <p>I have three tables in my DB, Student, Participant, and Activity. I'm trying to pull ALL the student names, activity names, and activity costs for all students participating in a certain activity. I'm wondering if this is possible. Here is the DB if you want to take a look: <a href="http://pastebin.com/QCsQfEKF" rel="nofollow">http://pastebin.com/QCsQfEKF</a></p>
  
  <p>Basically I want a table that looks like this:
  (ex. data)</p>
  
  <pre><code>Name  /         Activities        /Activities Cost
  carl  /basketball, golf           /$500
  jane  /pottery, skydiving, golf   /$600
  </code></pre>
  
  <p>and I want the data selected by giving a certain activty that they all participate in. </p>
  
  <p>I know how to do all of it except for the, selecting those who are all in a certain activity, part. </p>