SQL UNION and ORDER BY

I would like to have a

SELECT with an ORDER BY

And UNION this to another SELECT without an order by.

Is this possible?

It seems that SQL requires the ORDER BY to sort the entire result file.

Thanks



select fieldnames
FROM fileA

ORDER BY field1, field2



UNION all

SELECT
More field names
FROM from

______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________