请教一个AS的SQL语句问题

[jcins]

string t="select *,(select sum(zhangmudata.[zijin]) from zhangmudata where zhangmudata.fromid=zhangmu.[id] and [action]=1) as ruzhang,";
t+="(select sum(zijin) from zhangmudata where fromid=zhangmu.id and action=0) as chuzhang ";
t+="from zhangmu inner join login_user on zhangmu.fromuserid=login_user.userid"；
t += "order by ruzhang desc";

其中(select sum(zhangmudata.[zijin]) from zhangmudata where zhangmudata.fromid=zhangmu.[id] and [action]=1) as ruzhang这句在读取数据的时候用字段名ruzhang可以读取，但是不能order by，请教一下我要想按ruzhang 排序要怎么写？在MSSQL里这句就可以。麻烦大家帮帮忙！或者谁有其他的语句也可以实现这样的功能的！谢谢了！！

[WWWWA]

select * from (select *,(select sum(zhangmudata.[zijin]) from zhangmudata where zhangmudata.fromid=zhangmu.[id] and [action]=1) as ruzhang,
(select sum(zijin) from zhangmudata where fromid=zhangmu.id and action=0) as chuzhang
from zhangmu inner join login_user on zhangmu.fromuserid=login_user.userid)
order by ruzhang desc

也可以计算一下ruzhang 是第几列，比如10
则直接
t += "order by 10 desc";

[jcins]

用这个办法可以是可以了。不提示错误了，但是排序还是不行，不管是asc还是desc，结果都是升序排列。

[wwwwb]

不会吧，你的代码？