Normally records seem to arrive in RRN sequence - if no other ORDER BY is stated.
However, when I use UNION to concat two SELECT results together, they are arriving in a random sequence.
How can I assure that the result set is in RRN seq?
However, I don't think I can include RRN in the SELECT because that field is NOT in the result table.
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact