Sort by 2 colums as 1

[Icelizard]

I have 2 tables lets say called: files and notes
files has 2 fileds filname and date_added
notes has 2 fields note subject and date_added

if files had 2 records:
1) file1.pdf : 2007-06-14
2) file2.pdf : 2007-06-17

if files had 2 records:
1) great day out : 2007-06-15
2) why me? : 2007-06-18

i want to sort by the date in both fields but as if they were in 1 fields so output would be
2007-06-14
2007-06-15
2007-06-16
2007-06-17
and not
2007-06-14
2007-06-17
2007-06-15
2007-06-18

Any help would be breatly appreciated

 

[Kozusnik]

(select filename a, date_added b from files)
union
(select subject a, date_added b from notes)
Order by b

That should do it.

Mark

 

[Icelizard]

cheers thats good!