Join the result of 2 ordered queries without losing the order (in sql)

I have 2 queries, I need to have a query that outputs the result of query 1 and appends the result of query 2 after it:

query 1

SELECT *
FROM events
WHERE START >= '2010-1-1'
ORDER BY START 

query 2:

SELECT *
FROM events
WHERE START &开发者_StackOverflowlt; '2010-1-1'
AND END > '2010-1-1'
ORDER BY END

a result could be:

01 jan 2010 - 02 jan 2010 ->from query 1

02 jan 2010 - 01 feb 2010 ->from query 1

01 nov 2009 - 10 feb 2010 ->from query 2

01 oct 2009 - 11 feb 2010 ->from query 2

In other words, first the events that have not begun on the date yet ordered by start and then the events in progress ordered by end.

I can't seem to use join as that changes the order...

---

You could add dummy order by columns and UNION the results of both selects to return the results ordered as you like.

SELECT  *
        , 'Start' AS OrderBy1
        , Start AS OrderBy2
FROM    events
WHERE   START >= '2010-1-1'
UNION ALL
SELECT  *
        , 'End' AS OrderBy1
        , End AS OrderBy2
FROM    events
WHERE   START < '2010-1-1'
        AND END > '2010-1-1'
ORDER BY
        OrderBy1 DESC
        , OrderBy2