select a.a_aid, a.a_name, count(b.b_bid) as a_number
from a left join b on a.a_id = b.a_id
group by a.a_aid, a.a_name
select a.*,t.a_number
from a,(select a_id,count(a_id) as a_number from b group by a_id) as t
where t.a_id=a.a_id
我没看清，原来a_id在a表出现没在b表出现的也要统计啊。
select a.a_aid,a_name，count(b.a_id) as a_number
from a left join b on a.a_id = b.a_id
group by a.a_aid,a_name
a.* 你能查出来才出鬼了 你都分组了,哪能查a.*啊 就将这里改了就没问题了
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024