> > Q: Did you mean to exclude the 2nd "HIGH_FLOW" characteristic value from > > the summary? > > Yes, the same information should not be repeated within a single 'field'. The > second "HIGH_FLOW" characteristic is only in the original result set because > it > has 2 properties (> 10 litres / sec and > 50 gals / hour - sorry contrived I > know!) via the J_CHAR_PROPERTY table. > >> Q: Do you require the relationship/relative position between the >> "characteristic" and "property" values be maintained in the summary result? > > It would be nice, but not essential. Currently the 'properties' of a > 'characteristic' are not ordered to keep the example simple, but I could add a > SEQ field to define the ordering and in that case it would be good for the > LIST() to observe the order.
Have a look at my reply to your second question, about using CTE, that will be part of your answer for this problem as well. FYI: LIST() doesn't observe ORDER BY... Sean