select cpcase.jxsname as jxsname,jxs.name as name,sum(total) as zk,count(*) as num,sum(total-other) as qks from cpcase inner join jxs on jxs.id=cpcase.jxsname group by cpcase.jxsname,jxs.name order by qks desc
在SQL里好好的，到了access里就出错了"至少一个参数没有被指定值"