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
Brian Menke [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 07, 2007 6:23 PM
To: 'MySQL List'
Subject: How do I alter the result of a select
MySQL 5.x
I have a table that looks like this:
module_id question_id email participant_answer
2 2.1
MySQL 5.x
I have a table that looks like this:
module_id question_id email participant_answer
2 2.1 [EMAIL PROTECTED] a
2 2.2 [EMAIL PROTECTED] b
2 2.3 [EMAIL PROTECTED]