怎么写sql语句

[coolbird88]

表1
Userid Name
1 ewe
2 sdff
3 fsf
....
表2
Id Userid Pro
1 2 ddd
2 2 dsfsfd
3 2 sdf
4 3 fdsf
5 4 sdff

按name所拥有的表2中的pro所统计的数量进行高低排列，怎么写sql语句

[coolbird88]

获取name 以pro的数量做统计

[coolbird88]

顶

[slayerbb]

按name所拥有的表2中的pro所统计的数量进行高低排列 要獲取name還是pro

[coolbird88]

ding

[L5160729]

try
select count(*) pro from 表１ join 表２ on userid=name order by name desc

[半打啤酒]

try
select count(*) pro from 表１ join 表２ on userid=name order by name desc

UP

[xingdongfang]

select 表１.name isnull(t.c,0) as result
from 表１
left join (select count(Pro),Userid from 表１ group by userid) as t

[xingdongfang]

select 表１.name isnull(t.c,0) as result
from 表１
left join (select count(Pro),Userid from 表１ group by userid) as t
order by result asc

[xingdongfang]

打错了，请在最后一行，将表1改正为表2

[L5160729]

小鸟你咋不结帖呢?