How to group 1 to many into just 1 record?
Posted on 2012-03-23
Need a little help I have a query similary to :
select id, analyst, case, concat(comments + x.comments), rating from table1, (select id, analyst comments from table2) x where x.id=table1.id and table1.date_stamp between date 1 and date 2 . The query is working I am just missing one little thing.
Table 1 will only have 1 record per analyst
Table 2 could have multiple records that match up to that one record in table 1. How do I group all of the summaries out of table 2 to be shown as one summary to match the 1 record in table 1?
So for now my report looks like
Analyst Case Summary
TSMITH 11112 something
TSMITH 11112 something else
AND I WANT
TSMITH 11112 something something else
Can someone send me a link to a similar example that I can follow and use to fix what I am missing. Thanks.