求救这个MYSQL的查询语句怎么写

[shongshan]

查询用户名以发贴多少排列，要同时查询两个表！
select u_info.u_name as name,u_info.u_mail from u_topic,u_info order by (select count(u_topic.id) from u_topic,u_info where u_topic.u_name=name) asc

还有其它办法吗？order by 只能是后面只能是字段名吗，不能是其它条件吗？

[shongshan]

历害，这么多高手！谢了

[flymoon]

order by 只能是后面只能是字段名吗，不能是其它条件吗？

[xieweihua]

帮你顶

[feiyuwen]

select count(b.id) as count,a.u_name as name ,a.u_mail as mail from u_info a left join u_topic b using(u_name) order by count asc;
不能确定肯定可以运行，自己调试以下

[shiyonggang]

up

[niyboy]

order by count asc

应该就行了吧

[coolroy2000]

select count(b.id) as count,a.u_name as name ,a.u_mail as mail from u_info a left join u_topic b using(u_name) group by name,mail order by count asc;

这样即可！

[yb1682003]

好像我在书上看到运行MYSQL不支持子查询，不知是不是。

[singnet]

同意coolroy2000(coolroy)的做法