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
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
I have an application with many table joins and now I would like to get all
different Skills that every person in my resultset has concatenated to one
string.
I would like the code to work like this.
select concat_ws(", ",SkillName) as Skills, ..., ... from Skill, ..., ...
where ... and ... grou
