SQL query - Group By doesn't work

[MichaelR]

I have a table "Answer" like this:\[code\]Id, Registration_id, attendee_id, question_id, answer12 Reg02 1 1 Paul13 Reg02 1 2 Smith14 Reg03 2 1 Rachel15 Reg03 2 2 Silva\[/code\]My query is: \[code\]Select attendee_id, answerFrom wp_events_answer; \[/code\]As a result I obtain this:\[code\]attendee_id answer 1 Paul 1 Smith 2 Rachel 2 Silva\[/code\]But i'd like to have this:\[code\] attendee_id FirstName Name 1 Paul Smith 2 Rachel Silva \[/code\]I added \[code\]Group By attendee_id\[/code\]. But it still doesn't work. As a result it displays only this:\[code\] attendee_id FirstName 1 Paul 2 Rachel\[/code\]Can you please tell me what's wrong?Thanks