I want to do a Union of two different queries with each of the two queries sorted differently (using SQL Server 7.0). For example:SELECT StartDate, Duration, Title FROM Events WHERE Duration <= 7 ORDER BY StartDateUNIONSELECT StartDate, Duration, Title FROM Events WHERE Duration > 7 ORDER BY Title
My test results seem to indicate that you can only have one ORDER BY for the entire Union'ed resultset. I know I can fall back to using a Temporary Table and insert the subsets separately, but I'd rather not.Thanks in Advance...Mark