ora-00979!求,该怎么解决

ora-00979!!急求select mc.f_key,(select sum(sa.f_r-fsa.f_i) from c_sa),(select count(sa.f_r-fsa.f_i)

ora-00979!!急求
select mc.f_key,(select sum(sa.f_r-fsa.f_i) from c_sa),(select count(sa.f_r-fsa.f_i) from c_sa)
  from 
  zhangwl.c_sa sa,
  zhangwl.c_sa fsa,  
  zhangwl.c_MC mc 
  group by mc.f_key
ora-00979不是GROUP BY表达式

[解决办法]

SQL code
--你連關聯倏件都沒有,哥們你想做什麼select mc.f_key,a.sum1,a.count1  from    zhangwl.c_sa sa,  zhangwl.c_sa fsa,     zhangwl.c_MC mc,(select sum(sa.f_receivetime-fsa.f_issuetime) sum1,count(sa.f_receivetime-fsa.f_issuetime)count1 from zhangwl.cr_lwms_sa) a  group by mc.f_key;