Getting Duplicate Results Using Group_Concat - Help!
Hi there and thanks for looking!
I'm trying to return all names of answer attachments into one row per answer using the expression:
group_concat( fattach.userfname,' , ')
But the results show duplicates of each attachment name. />
I tried using distinct here: group_concat(distinct fattach.userfname,' , ') but the system wouldn't accept that. What am I missing? I attached the report definition. Any help is much appreciated!