SELECT *
FROM 部门表 A,
(
SELECT B.depid, COUNT(*) AS 员工数, SUM(C.payment) AS 工资总数
FROM 部门员工表 B, 员工工资表 C
WHERE C.usersid = B.usersid
GROUP BY B.depid
) D
WHERE D.depid = A.depid
select d.ddepname,count(distinct d.dusersid),sum(d.dpayment) from (select a.depname as ddepname,b.usersid as dusersid,c.payment as dpayment from a,b,c where a.depid=b.depid and b.usersid=c.usersid) d group by d.ddepname
改了下,家里电脑没装数据库,亲们帮忙看下是否有问题,该怎么改哈
select d.ddepname,count(d.dusersid),sum(d.dpayment) from (select a.depname as ddepname,b.usersid as dusersid,c.payment as dpayment from a,b,c where a.depid=b.depid and b.usersid=c.usersid) d group by d.ddepname
我的思路大概是这样,亲们看看应该怎么写才好哈,谢谢啦