I have a SELECT statement that has a few unions. I dont use ORDER BY because I want to have selected records in the order I am selecting them in the Unions. But that's not happening. Any help, please?

Thanks, Mark