select a.djbm,sum(a.je1),sum(b.je2)
from a join b
on a.djbm=b.djbm
group by a.djbm
from a join b
on a.djbm=b.djbm
group by a.djbm
解决方案 »
- 末设置主键的情况下,如何实现将A表中的前10条记录剪切到B表中?
- 在SQL里怎样计算得到这样的日期?
- 高手帮帮忙吧,100分相送,解决马上结帖
- SQL SERVER生成字符串
- 难,关于数据库collation的问题
- 高手必进!!!!!!!case 和 IF 相互转换的问题
- 请问各位老大:“SELECT 'Return Status' = @return_status”这句话什么意思?
- 以下存储过程为何返回错误:“对象名 '#abc' 无效。”加急!解决就给分。
- help!!!我想找Toadfree,哪位有,请给我发一份好吗,谢谢!
- 有点难度的条件查询后保存到另一表里
- 一个简单的查询问题
- 查询的问题,各位达人帮帮忙
(select djbm,sum(je1) 和 from a group by djbm
union all
select djbm,sum(je2) 和 from b group by djbm) tem group by djbm
谢谢您的回复是这样吗:
select * from (select djbm,sum(a.je1) as je1 from a group by djbm union select djbm,sum(b.je2) as je2 from b group by djbm)) tem where tem.je1>tem.je2
-------------------------------------------------
djbm je1
01 10
02 5
03 2
01 20
02 10
________________________________________________
b
------------------------------------------------
djbm je2
01 10
02 20
01 10
02 20
我想得到的表c
-------------------------------------------------
djbm je1 je2
01 30 20
02 15 40
03 2 0我最终要得到的表 条件是:je1>je2
d
--------------------------------------------------
djbm je1 je2
01 30 20
03 2 0--------------------------------------------------
谢谢
SELECT A.DJBM AS BM,SUM(JE1) AS S FROM A GROUP BY A.DJBM
) AS AA FULL JOIN (
SELECT B.DJBM AS BM,SUM(JE2) AS S FROM B GROUP BY B.DJBM ) AS BB
ON AA.BM=BB.BM
GROUP BY AA.BM
HAVING SUM(ISNULL(AA.S,0))>SUM(ISNULL(BB.S,0))
SELECT A.DJBM AS BM,SUM(JE1) AS S FROM A GROUP BY A.DJBM
) AS AA FULL JOIN (
SELECT B.DJBM AS BM,SUM(JE2) AS S FROM B GROUP BY B.DJBM ) AS BB
ON AA.BM=BB.BM
GROUP BY AA.BM
HAVING SUM(ISNULL(AA.S,0))>SUM(ISNULL(BB.S,0))
(select djbm,sum(je1) je1 from a group by djbm) join
(select djbm,sum(je2) je2 from b group by djbm)
on a.djbm=b.djbm where a.je1>b.je2
select a.djbm,a.je1,b.je2 from
(select djbm,sum(je1) je1 from a group by djbm) a join
(select djbm,sum(je2) je2 from b group by djbm) b
on a.djbm=b.djbm where a.je1>b.je2或:
select djbm,sum(je1) je1,sum(je2) je2 from
(select djbm,je1,0 je2 from (select djbm,sum(je1) je1 from a group by djbm) a
union all
select djbm,0 je1,je2 from (select djbm,sum(je2) je2 from b group by djbm) b) tem group by djbm