I have a table ‘actions’ which has the following fields


I want to produce a table where the notes are gathered together by staffid and date.

For example if person with staffid=1 on May 1st produced 3 different actions with notes on action1, notes of action 2, notes of action 3, the table would show:

staffid | date | notes
1 | 2014-05-01 | notes onaction1. notes of action 2. notes of action 3.

I tried concat but this didn’t seem to work.

Does anyone have any suggestions?