You're not really explaining the issue you are having. I get that you want a sort order among the queries, but what don't you understand or what doesn't work?
Attempting to ORDER BY DateTime and ORDER BY Exception_DateTime (so both queries sort into one table by Date then Time)
I apologize for not being more clear. I need both of these queries to place the data into one output and sort the data by Date then Time.
.
This is exactly why we ask for sample data and expected results. It provides very clear starting and end points. There are links in my signature about how to do so.
Also, sorting by date then time is easy. All you have to do is sort on a datetime field.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA