很急！group by 的排序问题！

[yoohoowang]

//行业表（tbl_hy）,产品表(tbl_cp).产品表中含行业ID字段(hy_id).
//统计各行业的产品(cp_id)数量,并按行业名称排序(同时取得hy_id和ht_mc的值)。
select a.hy_id,a.hy_mc,count(b.cp_id) as cnt from tbl_hy as a,tbl_cp as b where a.hy_id=b.hy_id group by a.hy_id,a.hy_mc
//问：怎么样才能使搜索结果按行业名称（hy_mc）排序？

[playyuer]

'升序
select a.hy_id,a.hy_mc,count(b.cp_id) as cnt from tbl_hy as a,tbl_cp as b where a.hy_id=b.hy_id group by a.hy_id,a.hy_mc
ORDER BY a.hy_mc
'降序
select a.hy_id,a.hy_mc,count(b.cp_id) as cnt from tbl_hy as a,tbl_cp as b where a.hy_id=b.hy_id group by a.hy_id,a.hy_mc
ORDER BY a.hy_mc DESC

[jcq]

select a.hy_id,a.hy_mc,count(b.cp_id) as cnt from tbl_hy as a,tbl_cp as b where a.hy_id=b.hy_id group by a.hy_id,a.hy_mc order by a.hy_mc

[yoohoowang]

thanks