This content has been marked as final. Show 4 replies
> 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.
I just figured that out. Thanks for the reply. Now if I could just keep it from reordering the contents of each set...
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.
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.