>Caroline,
>
>>Would you know if there is a way to force the group by to return say records of type 1 if the pre Group By result holds both a type 1 and a type 0?
>
>I'm not sure, if I understand what you want to do ...
>
>Armin

If you ran your select without the Group By your result would contain some Keys with both a type 1 and a type 0. I would like to force the Group By to select the records of a particular type first so that the result would contain Type 1's if both 1's and o's where present.

Is that any clearer?