Re: How do I alter the result of a select

2007-03-07 Thread Dan Buettner
Brian, the online MySQL documentation is very complete and easy to read. That said, you do kind of have to know what you're looking for! I'm not sure what to recommend for a guide to beginning SQL, sorry, others may have some thoughts. You are going down the right road with an aggregate function

RE: How do I alter the result of a select

2007-03-07 Thread Brian Menke
I ended up figuring this out. If anyone ever needs it, this works well select module_id, GROUP_CONCAT(participant_answer SEPARATOR ' ') as answers from participants_answers where email = '[EMAIL PROTECTED]' group by module_id -Brian -Original Message- From: Brian Menke [mailto:[EMAIL