SQL sorting

[Florian Bogeschdorfer]

Hi list!

 I have two tables, each has a date and a time field :

TABLE1
myDateField1
myTimeField1
Other fields...

TABLE2
myDateField2
myTimeField2
Other fields...


Now I would like to make a search over both tables and sort the data first
by date then by time

1. How can I sort by date and after that by time?

2. The date fields and time fields have different names in both tables but I
would like to sort like this:

TABLE1
01.11.2003
25.08.2003

TABLE2
10.10.2003



Wanted result: 
25.08.2003
10.10.2003
01.11.2003


How can I do this?

TIA, Florian