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.