多表查询并求和的查询语句如何写啊! 有两个表如下,表1NO val11 3001 2002 1002 200表二No val21 10002 270查询结果要求是No val1 val21 500 10002 300 270 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select a.no,val1,val2from(select no,val1=sum(val1) from ta group by no)a,(select no,val2=sum(val2) from tb group by no)bwhere a.no=b.no SELECT A.NO,A.val1,B.val2FROM(SELECT NO,SUM(val1) AS val1 FROM 表1 GROUP BY NO) A JOIN 表二 B ON A.NO=B.NO select t2.no , (select sum(val1) from t1 where t1.no = t2.no) val1 , val2 from t2 create table t1(NO int,val1 int)insert into t1 values(1 ,300)insert into t1 values(1 ,200)insert into t1 values(2 ,100)insert into t1 values(2 ,200)create table t2(No int,val2 int)insert into t2 values(1 ,1000)insert into t2 values(2 ,270)goselect t2.no , (select sum(val1) from t1 where t1.no = t2.no) val1 , val2 from t2drop table t1 , t2/*no val1 val2 ----------- ----------- ----------- 1 500 10002 300 270(所影响的行数为 2 行)*/ create table t1(NO int,val1 int)insert into t1 values(1 ,300)insert into t1 values(1 ,200)insert into t1 values(2 ,100)insert into t1 values(2 ,200)create table t2(No int,val2 int)insert into t2 values(1 ,1000)insert into t2 values(2 ,270)go--如果你两表no不一定存在对应select t2.no , (select sum(val1) from t1 where t1.no = t2.no) val1 , val2 from t2 order by t2.no--如果你两表no一定存在对应select t2.no , sum(val1) val1 , t2.val2 from t2 , t1 where t2.no = t1.no group by t2.no , t2.val2 order by t2.no drop table t1 , t2/*no val1 val2 ----------- ----------- ----------- 1 500 10002 300 270(所影响的行数为 2 行)*/ 两个函数显示成一个字段如(总邮件/总金额) 数据检索 请问如何设置SQL Management才能在里面可以重启服务 关于server 2003下的SQL的问题 远程访问SQL SERVER数据库 sqlserver 中为何一次只能取256个字节! 请问Sql语句怎么写??? 怎样写这种SQL一对多查询 数据导入问题 请问一个关于SQL语句的问题? 帮忙看一下这两条SQL语句的区别? 急需要sql语句!!!
from
(select no,val1=sum(val1) from ta group by no
)a,
(select no,val2=sum(val2) from tb group by no
)b
where a.no=b.no
FROM
(SELECT NO,SUM(val1) AS val1 FROM 表1 GROUP BY NO) A JOIN 表二 B ON A.NO=B.NO
insert into t1 values(1 ,300)
insert into t1 values(1 ,200)
insert into t1 values(2 ,100)
insert into t1 values(2 ,200)
create table t2(No int,val2 int)
insert into t2 values(1 ,1000)
insert into t2 values(2 ,270)
goselect t2.no , (select sum(val1) from t1 where t1.no = t2.no) val1 , val2 from t2drop table t1 , t2/*
no val1 val2
----------- ----------- -----------
1 500 1000
2 300 270(所影响的行数为 2 行)
*/
insert into t1 values(1 ,300)
insert into t1 values(1 ,200)
insert into t1 values(2 ,100)
insert into t1 values(2 ,200)
create table t2(No int,val2 int)
insert into t2 values(1 ,1000)
insert into t2 values(2 ,270)
go--如果你两表no不一定存在对应
select t2.no , (select sum(val1) from t1 where t1.no = t2.no) val1 , val2 from t2 order by t2.no--如果你两表no一定存在对应
select t2.no , sum(val1) val1 , t2.val2 from t2 , t1 where t2.no = t1.no group by t2.no , t2.val2 order by t2.no drop table t1 , t2/*
no val1 val2
----------- ----------- -----------
1 500 1000
2 300 270(所影响的行数为 2 行)
*/