I have created a view that pulls data from several tables that have a 1:n relationship. For example, I have people with different roles. And they can have more than one role. When the data is retrieved then I get for example rows of data like this:
ADAM | FOH |
ADAM | CHEF |
What I want to be able to do is combine the roles so that I just get one row like:
ADAM | FOH, CHEF |
Thanks in advance.