I have 3 related tables: Claims, Names, Judicial
Each claim can have several names, but only one Judicial info.
I've created a view where I can list just the fields I want from each table, but it shows a row for each name, repeating for each one the Claim ID and all the Judicial Info. I would like it to be grouped (?) and show an array(?) of the names, separated by a comma.
What it shows now:
ClaimID Names Court Name City Fee
-------------------------------------------------------------------------------
100001 Joe Court Name Chicago 100
100001 Tom Court Name Chicago 100
100001 Lisa Court Name Chicago 100
What I would like:
From ClaimID (there is only one field) | Names (all on the same row separated by a comma) | From Judicial (Court name, City, Court Fee)
ClaimID Names Court Name City Fee
----------------------------------------------------------------------------
100001 Joe, Tom, Lisa Court Name Chicago 100
Can I achieve this through grouping by multiple columns? And how can I make the names array(?)?
Thanks in advance.