On Wed, Aug 13, 2008 at 4:27 PM, Clinton Begin <[EMAIL PROTECTED]> wrote: > 4. groupBy is gone completely. The <collection> element combined with the > ID element now work together to achieve this. I agree the old > implementation was annoying. What do you mean by multiple independent > lists? Does that not work now?
I *think* he's referring to something like where you have people that have cats and dogs. Say you have a PERSON table, a DOG table, and a CAT table. If DOG has a person_id and CAT has a person_id, and you join the three tables, you can't get a list of person objects each with the correct list of dog and cat objects. I've not really understood the desire for this one, because you can't really do that effectively with SQL, either - so instead of 1+N selects, you do one select that returns m*n*o records. So for 10 people with 10 dogs and 10 cats, you get 1000 records instead of the 200 that 1+N selects get you. Rick has whined about that one for years. ;-) Larry
