Displaying multiple values in a table field with multiple joins

Hi all,

I am trying to create a table where a field value is displayed multiple times, with each value separated by a comma in the same record, instead of having multiple records.

For example: I have 3 tables: specialist, locations, and specialistLocations table for the many-to-many relationship. I want to create a table in Wappler that displays all the clients and the multiple locations that each client can be present in. like this:

I have tried making the following database query, but I cant map multiple locations in a single cell under the locations column in the table.

image759×92 3.12 KB

Can someone provide any suggestions on how the database query should be, or is this something that should be configured from app connect side.