Hello MySQL List
I have a simple table that outputs results like so:
select name, question_id, answer from table;
+-------+--------------+---------+
|NAME |QUESTION_ID |ANSWER |
+-------+--------------+---------+
|Mark |100 |Yes |
|Mark |101 |No |
|Leigh |100 |Yes |
|Leigh |101 |No |
+-------+--------------+---------+
Is there a way to query things so the result looks like this:
select ???
+--------+-----------+-----------+
|NAME |100 |101 |
+--------+-----------+-----------+
|Mark |Yes |No |
|Leigh |No |Yes |
+--------+-----------+-----------+
cheers
Mark Dale
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
