In my applcation, I have agents that are associated with multiple of loations, so my database is as follows (in bold are my table names, followed by field names):
so my last table is a linked table.
My question is, how can I SELECT * FROM locations, and all the agent_id(s) from the location_agent_assoc table as a comma-separated list?
I am hoping to get a row source similar like
id name address agent_ids
1 the mall 123abc 1,7,8,25
2 the musium 456no st 32,2,78