Only if you can use the UNION operator on two queries.
Otherwise, the dates will come out as two columns, so you cant sort on both at the same time. if you do this:
SELECT date1, date2
FROM table1, table2
WHERE something=somethingelse
ORDER BY date1, date2
it will order by date1, and if there are dates in date1 that occur more than once, the date2 values for those dates are sorted.
1jul2001 29 aug 2000
2jul2001 30 aug 2000
2jul2001 31 aug 2000
3jul2001 1 jan 2000
