sql统计排序语句

[gwins]

有以下三个表，字段如下示：
一个会员表：UID,UName

一个新闻评论表：NID,UID

一个产品评论表：PID,UID

请问如何写这个查询语句，按评论的多少显示会员名称，评论数。

[htl258_Tony]

select uname from 会员表 a join 新闻评论表 b on a.UID=b.UID group by Uname order by count(1) desc

[htl258_Tony]

select uname 
from 会员表 a 
  join (
    select * from 新闻评论表
     union all
    select * from 产品评论表
    ) b 
    on a.UID=b.UID 
group by Uname order by count(1) desc

[gwins]

是统计每个会员的所有评论（新闻评论和产品评论）

[老黎]

select a.*
from 会员表 a
    left join 
(
select UID,[cnt]=count(1)
from
(
select NID,UID from 新闻评论表
union all
select PID,UID from 产品评论表
) a
) b
on a.UID = b.UID
order by isnull(b.cnt,0)

[htl258_Tony]

[Quote=引用 3 楼 gwins 的回复:]
是统计每个会员的所有评论（新闻评论和产品评论）
[/Quote]

select uname 
from 会员表 a 
  left join (
    select * from 新闻评论表
     union all
    select * from 产品评论表
    ) b 
    on a.UID=b.UID 
group by Uname 
order by count(b.UID) desc

所有会员这样。

[老黎]

--少了group by
select a.*
from 会员表 a
    left join 
(
select UID,[cnt]=count(1)
from
(
select NID,UID from 新闻评论表
union all
select PID,UID from 产品评论表
) a
group by UID
) b
on a.UID = b.UID
order by isnull(b.cnt,0)

[--小F--]

[Quote=引用 2 楼 htl258 的回复:]
SQL code

select uname
from 会员表 a
join (
select * from 新闻评论表
union all
select * from 产品评论表
) b
on a.UID=b.UID
group by Uname order by count(1) desc
[/Quote]
up

[gwins]

还有一个问题，这个具体的评论数如何读取？

[gwins]

问题已解决，谢谢

SQL语句如下：
Select count(1) As Result,a.uname From 会员表 As A join (Select * From 新闻评论表 Union All Select * from 产品评论表) As B on A.UID=B.UID group by a.uname order by Result desc

[bl_song]

不错，记下！