求sql语句
access数据库
员工表:yg
ID ygNAME price
1 a君 1222
2 b君 1300
3 c君 3000
4 d君 3050
5 e君 3050
6 f君 3080
员工部门表:ygbm
ID ygNAME bm
1 a君 it
2 b君 it
3 c君 sale
4 d君 sale
5 e君 it
6 f君 sale
部门表:bm
ID bmNAME
1 it
2 sale
得出结果
ID bm sumprice
1 it 6500
2 sale 7800
[解决办法]
select bm,sum(price) sumprice
from yg,ygbm
where yg.ygname=ygbm.ygname
group by bm
[解决办法]
select y.bmid,y.bmname,sum(y.price) from (select bm.id as bmid,bm.bm as bmname,yg.price as price from yg,ygbm,bm where yg.ygname = ygbm.ygname and bm.bm = ygbm.bm) y group y.bmname
[解决办法]
select abm,sum(aprice) from (select ygbm.bm as abm,yg.price as aprice from ygbm inner join yg on ygbm.ygName=yg.ygName) a group by bm
[解决办法]
随便写了下,没测试:
select bm.id,bm.bmNAME,a.sumprice from bm left OUTER JOIN
(
select ygbm.bm,sum(yg.price) as sumprice from yg left OUTER JOIN ygbm on yg.id=ygbm.id group by ygbm.bm
) a
on bm.bmNAME=a.bm
[解决办法]
你的工资是不是自已算错了
[解决办法]
SELECT T1.bmNAME,SUM(T3.price)
FROM bm T1
LEFT JOIN ygbm T2 ON T1.bmNAME = T2.bm
LEFT JOIN yg T3 ON T2.ygNAME = T3.ygNAME
GROUP BY T1.id,T1.bgName
[解决办法]
sskset(断点) is right!
