SQL语句 我有两张表A B现在我想查找A表的所有的的记录 和B表中 Money 字段的总和 id ='XXX'的记录(AB表都有id这字段)举个例子查找出来的结果是id name money1 KK 9992 yy 888 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select a.ID,a.Name,[money]=sum(isnull(b.[money],0))from aleft join b on a.ID=b.IDgroup by a.ID,a.Name select a.id,a.name,sum([b.money]) as [money]from a join b on a.id=b.idwhere b.id='xxx'group by a.id,a.name select a.id,a.name,sum([b.money]) as [money]from a join b on a.id=b.idwhere b.id='xxx'group by a.id,a.name select a.id,a.name,sum([b.money]) as [money]from a inner join b on a.id=b.id and b.id='xxx'group by a.id,a.name 能不能不写a.id,a.name,用一个简洁的方法来写啊,我有很多的字段呢 select a.id,a.name,sum([b.money]) as [money] from a join b on a.id=b.id where b.id='xxx' group by a.id,a.name 那你就select a.*,b.XX,c.XX from .... 可以不写啊,去掉不就行select sum([b.money]) as [money] from a join b on a.id=b.id where b.id='xxx' group by a.id,a.name a与b进行左联接,再聚合查询select a.id,a.name,sum(isnull(b.money,0)) as [money] from a join b on a.id=b.id where b.id='xxx' group by a.id,a.name select sum(b.money) as money from a join b on a.id=b.id where b.id='xxx' group by a.id,a.name select a.id,a.name,sum([b.money]) as [money] from a join b on a.id=b.id where b.id='xxx' group by a.id,a.name 请高手帮忙修改一条SQL语句 sql 语句 截取2个字符之间内容 一个关于复制服务的问题 触发器IF update后的语句操作对象是更新前还是更新后??? vc6+ado+listcontrol,不能显示数据,请大神们看下 SQL中type in(N'U')是什么意思啊,高手们 马可大哥在吗?我在SQL语句中用变量还是不行啊,我也看了你那篇"[交流]动态SQL语句"!!! 如何将需要的图片存在数据库中??? 请教一下一个关于SQL SERVER进程阻塞的问题! 请问,同一实例中,如何把一个数据库中的一张表拷贝到别一个数据库中(如果同名表则覆盖)?谢谢! 数据库表关系 TOP*TOP查询不对
select
a.ID,a.Name,[money]=sum(isnull(b.[money],0))
from
a
left join
b on a.ID=b.ID
group by a.ID,a.Name
from a join b on a.id=b.id
where b.id='xxx'
group by a.id,a.name
from a join b on a.id=b.id
where b.id='xxx'
group by a.id,a.name
from a
inner join b
on a.id=b.id and b.id='xxx'
group by a.id,a.name
select a.id,a.name,sum([b.money]) as [money]
from a join b on a.id=b.id
where b.id='xxx'
group by a.id,a.name
select sum([b.money]) as [money]
from a join b on a.id=b.id
where b.id='xxx'
group by a.id,a.name
select a.id,a.name,sum(isnull(b.money,0)) as [money]
from a join b on a.id=b.id
where b.id='xxx'
group by a.id,a.name
from a join b on a.id=b.id
where b.id='xxx'
group by a.id,a.name
from a join b on a.id=b.id
where b.id='xxx'
group by a.id,a.name