求SQL多表连接查询并统计求和的语句~~~~???急!!对的~~即给分~~限时两天! select a.id,a.name,a.count count(b.id)from a,b where a.id =b.idgroup by a.id 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select a.aa,a.bb,a.cc ,(select count(b.aa) from b where b.aa = a.aa)from a select a.aa,a.bb,a.cc, count(b.aa)from a left join b on a.aa =b.aagroup by a.aa,a.bb,a.cc select B.id,count(*) as num from A,B where A.ID=*B.id group by A.ID select A.[ID],name,B.Num from #A A,(select ID,count(ID) as Num from #B group by ID) Bwhere A.ID=B.ID select A.ID,A.name,c.Countfrom A left join (select B.ID,B.name,count(*) as Count from B group by B.ID,B.name)c on (A.ID = c.ID and A.name = c.name) select A.ID,A.Name,(select count(B.ID) from B where B.ID = A.ID)from A select a.id,name,count(b.id) from a inner join b on a.id=b.id 如何解决数据写入自带空格 请问mssql如何查找实例名? 求一查询语句 求助 为什么我的1433端口没打开 从结果集中取出 最后20条记录 我的问题比较麻烦,大家给看看我设计的数据库有什么问题! 关于效率和方便性的矛盾,有什么好的解决办法? 一级类别 二级类别 三级类别 产品 数据库怎样设计更合理? 一个数据表的显示问题 100分在线 求一个存储过程改造 请问怎么搜索在ACCESS数据库中日期小于2000-1-1日所有记录
from a
from a left join b on a.aa =b.aa
group by a.aa,a.bb,a.cc
where A.ID=B.ID
from A left join
(select B.ID,B.name,count(*) as Count from B group by B.ID,B.name)c
on (A.ID = c.ID and A.name = c.name)
from A