>>The only SELECT caluse taht is applicable to the result of UNION is ORDER BY. You can run one more select of the cursor created by UNION with your WHERE conditions.
>
>I am a little confused. Please clarify something. I understand what you said about ORDER BY. But regarding your second sentence, are you saying that I would need to have another SQL Select on the resulting cursor and that would be the only way to "filter" the resulting cursor?
Yes unless you're willing to repeat WHERE clause in each select in UNION SELECT itself.
--sb--