var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Joining text together in a query
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?