Ill try explain in simple terms.
Table A is Cases
The ID is id
Table B is CaseComments
The join would be in : casecomments.caseid = cases.id
The thing is that for each case there might be several case comments, if I do a query and do a left join to case comments from cases then I will get one recordset for each comment, which is not what I need. What I need is to display all comments in a column. So that I end up with something like:
Caseid, case number, process, etc .. , [CASECOMMENTS] (All of them separated by a dash or whatever, in one column)
Next record &. Etc
Is it possible to do this with SQL ?
Appreciate your help.