Query of Query - union resorts the dataset?

[Tinaja]

It appears that when I try to union two queries, something is reordering everything. I have 2 separate queries that need to be unioned, but with the first query's results showing first, then the second queries results. This is ending up in a select list, so order is important.

How do I get around this behavior?

[Newsgroup_User]

> How do I get around this behavior?

Add a field to each record set with a value that distinguishes one set
from the other in the desired order. Then in the QofQ union add an
order by clause to the end that utilizes this field.

[Tinaja]

I just figured that out. Thanks for the reply. Now if I could just keep it from reordering the contents of each set...

[Dan_Bracuk]

quote:

---

Originally posted by: Tinaja
It appears that when I try to union two queries, something is reordering everything. I have 2 separate queries that need to be unioned, but with the first query's results showing first, then the second queries results. This is ending up in a select list, so order is important.

How do I get around this behavior?

---

Think about what you are trying to accomplish. The statements, "need to be unioned" and "first query results showing first" contradict each other.

[Tinaja]

Actually it's all in your definition of "union" isn't it? I expected it meant concatenation. Obviously it doesn't :)

I got it worked out - thanks for the help.