Re: concatenate text content in column grouped by another column.

2001-11-26 Thread Eva Fransson
No concatenation is being done in my example. that is what is wrong. the result I get is only one of the SkillName values. I would like all possible SkillNames to be listed in Skills on the same row in the resultset, grouped by fkEmployeeID. I have tried out having and I can not see any need to u

Re: concatenate text content in column grouped by another column.

2001-11-26 Thread sherzodR
Does it throw an error message or output isn't what you expected? In any event, did you try it with "HAVING"? I couldn't notice anything wrong from what you have there Cheers -- sherzodR On Mon, 26 Nov 2001, Eva Fransson wrote: >I have an application with many table joins and now I would