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 ... group by fkEmployeeID order by ... , ... limit 0,20; But it dosn't! Is there some other way to fix this? Eva Fransson --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php