4 Replies Latest reply on Oct 18, 2007 8:52 PM by Tinaja

    Query of Query - union resorts the dataset?

      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?