select 排序问题(58分)

各位大侠:
我想请教一个问题
表A name time key1
a 2003 c
g 2004 c
b 2005 d
d 2002 c
f 2004 d
我用得是这样一条语句
select name from A where key1="c"
union select name from A where key1="D"
请问如何将上两条语句得到的结果根据时间进行排序
name time key1
d 2002 c
a 2003 c
g 2004 c
f 2004 d
b 2005 d
多谢大家!!!!

就在where后家order by好了
select name,'1' as pxh from A where key1="c"
union select name,'2' from A where key1="D" order by pxh,time

select name from A where key1="c"
union select name from A where key1="D" order by key1,time

多人接受答案了。

select name,time from A where key1='c'
union select name,time from A where key1='d' order by time