求解释 : SELECT employee.组别,employee.姓名 as 负责人,sum(orders.金额)as 合计; from 订单管理!employee inner join 订单管理!orders; on employee.职员号=orders.职员号; where employee.职务="组长"; group by employee.组别; order by 3 desc; into table tabletwo.dbf
