<http://schema.org/articleBody>
"Beginning with Release 6.1 it is possible to include ORDER BYs into the Sub-Selects. But IMHO it does not guarantee that final result is returned in this sequence. In this way you may add additional sort columns into the sub-selects and add a final Order by based on this sort keys. Example: Select a.*, 1 SortFile, Row_Number() Over(Order By Key1, Key2, ... KeyN) SortKey ... Union Select b.*, 2 , RRN(b), .... Select c.*, 3, RRN(C) .... Order By SortFile, SortKey Mit freundlichen Gr&amp;#xFC;&amp;#xDF;en / Best regards Birgitt..."^^<http://www.w3.org/2001/XMLSchema#string>
<http://archive.midrange.com/midrange-l/201402/msg00346.html>