高手帮忙！SQL语句加上union后不能用order by？？？？？

[lz_zxf]

如下句：
SELECT DATE,SC_NO,SC_NAME,TOTAL,OLD_TOTAL FROM 2002\03SCXS WHERE DATE >= {03-21-2002} AND SC_NO='2' UNION SELECT DATE,SC_NO,SC_NAME,TOTAL,OLD_TOTAL FROM 2002\04SCXS WHERE DATE =< {04-05-2002} AND SC_NO='2' order by date descending
给出错误：ORDER BY clause is invalid.
去掉order by 字句没有问题。但是我要排序呀。（foxpro数据表）

[jxwangzhigang]

SELECT DATE,SC_NO,SC_NAME,TOTAL,OLD_TOTAL FROM 2002\03SCXS a WHERE DATE >= {03-21-2002} AND SC_NO='2' UNION SELECT DATE,SC_NO,SC_NAME,TOTAL,OLD_TOTAL FROM 2002\04SCXS b WHERE DATE =< {04-05-2002} AND SC_NO='2' order by a.date descending
加上数据库别名吧!

[genuis]

order by date desc

[goldmoon]

同意楼上的，ORDER BY date DESC

[lz_zxf]

descending和desc没有区别吧？
我用order by date也是一样的。