表1
字段分别为
userid userphone useradder
10001 1300250000 liaoning
10002 130880000 liaoning
10003 137750000 liaoning
表2 字段为
userid userinfor
10001 1111111111
10001 122222
10001 333333333
10002 fgdfgdfgdfgdfgdfgdfgdfgdfg
10002 gggggggg
查询后的结果是
userid userphone useradder 数量
10001 1300250000 liaoning 3
10002 130880000 liaoning 2
10003 137750000 liaoning 0
这个查询该如何写.谢谢了
------解决方案--------------------
select userid , userphone,useradder,count(*)
from tb1 join tb2 on tb1.userid=tb2.userid
group by userid , userphone,useradder
------解决方案--------------------
select *,
(select count(1) from tb2 where userid =a.userid )
from tb1 a
------解决方案--------------------
select userid , userphone,useradder,count(*)
from tb1 inner join tb2 on tb1.userid=tb2.userid
group by userid , userphone,useradder
------解决方案--------------------
select t1.*,t3.数量 from t1 left join (select userid,count(1) as 数量 from t2 group by userid) t3 on t1.userid=t3.userid