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]