I have a table or WorkOrders that simply specifies the workordernumber, name, and description. I have another table of WorkOrderDetails that contains a foreign key linked to the workordernumber (workorderidfk) and that lists the ids for the person, parts, purposes and approvals of the work. It could be on a single workorder that a single part in the details sections might have multiple purposes and that for a single purpose is might have multiple approval codes. Obviously since the workorderdetails table contains id references to other tables such as parts, I have multiple joins to display the actual names of the objects. I have painstakingly tried and failed to use string_agg with a subquery and other methods to produce a view or query that simply aggregates WITHOUT DUPLICATES the details for each WorkOrder. For instance, Workorder Number 1 should show PersonA,Part1\Part2\Part5,Purpose1\Purpose2,Approv alCode1. For this exercise I am not concerned about the actual relationships within the details. I am literally trying to produce a list of each distinct aggregation for each column and combine that into a unique view. But to no avail. I also tried other methods other than string_agg and could not get this to work. It always produces something like PersonA/PersonA, Part1/Part1/Part2,Purpose1/Purpose2/Purpose2,ApprovalCode1. Any ideas? Basically I think if I could create a view or a new table pulling each column from the workorder table where I pull all distinct values from each column and aggregate them into a new field and then combine that with the same operation on every other column in the details table, that would do what I need. Any ideas greatly appreciated!