Hmmmm... Well, maybe for debugging it helps to do it twice, but speed is important and it seems that having it in one select would be faster.

Thanks,

Michelle


>Sometimes it is easier - among others, for debugging purposes - to separate a single SQL - SELECT command into several.
>
>

>SELECT ... (union goes here) ... into cursor Tmp nofilter
>SELECT * from Tmp into cursor Tmp group by MyField
>

>
>Yes, you can (usually) send the result from cursor Tmp back into cursor Tmp! However, again for debugging purposes, you may want to keep a separate cursor.