Providing an exact duplicate of your original message is not going to make your objectives any clearer. Specifically, it is not going to answer the question of why you do not want to use UNION when that is most likely going to be the best approach.

There are only two reasons not to use UNION:

* There is a better approach.

* This is homework and the homework specifies that you can't use UNION.

I suspect the answer is the second one, especially since your response for more details was an exact duplicate of your original question.

Drew